Ai visibility local
Local only

Run item

gemini · looker · question_index=5

Question

What are some other business intelligence tools like DBT?

Answer

While dbt (data build tool) is primarily a data *transformation* tool that helps analytics engineers transform data in their warehouse using SQL, it's often a foundational component of a broader business intelligence (BI) stack. It brings software engineering practices like version control, testing, and documentation to data workflows. When looking for tools "like dbt," you might be seeking: **1. Data Transformation Tools (Alternatives/Competitors to dbt):** These tools also focus on preparing and modeling data, often using SQL or visual interfaces. * **SQL-based Transformation Tools:** * **Dataform:** Now part of Google Cloud, Dataform is a native SQL transformation tool similar to dbt, tightly integrated with BigQuery. * **SQLMesh:** An open-source Python framework that manages SQL file execution in DAG order and is backward compatible with dbt. It takes a declarative approach to building and managing SQL models. * **Coalesce:** A cloud-native transformation, catalog, and governance platform that offers a visual and modular development environment for both code-first SQL and GUI-driven workflows. * **Graphical ETL/ELT Tools (often with transformation capabilities):** These tools provide visual interfaces for building data pipelines, including transformation steps. * **Matillion:** A cloud-native ETL/ELT platform with a visual, low-code interface designed for cloud data warehouses, and it includes a native dbt Core component. * **Informatica:** An enterprise data integration platform with extensive ETL capabilities and data quality tooling. * **Talend (Qlik):** Known for its integration, data quality, and governance features, offering both open-source and enterprise solutions. * **Alteryx:** A self-service analytics and data preparation platform that offers a low-code approach, aimed at business users. * **AWS Glue:** A fully managed ETL service that handles infrastructure for data transformation. * **Azure Data Factory:** Microsoft's native orchestration service for cloud and hybrid data pipelines. * **Data Orchestration Tools (which can include transformation):** * **Apache Airflow:** An open-source tool for orchestrating data workflows using Python, often used to schedule and manage dbt jobs or custom ETL pipelines. * **Dagster:** A modern orchestration platform that offers Python-native workflows for complex pipelines and can run dbt models as part of broader workflows. **2. Business Intelligence (BI) Tools (which commonly integrate with dbt):** These tools focus on data visualization, reporting, and dashboarding, consuming the transformed data from dbt or similar tools. Many BI tools seamlessly integrate with dbt to leverage its defined data models and metrics. * **Looker:** A powerful BI tool focused on data modeling using its proprietary language, LookerML, and is part of Google Cloud. It excels in governed, model-driven environments. * **Metabase:** An open-source BI platform known for its user-friendly interface for internal analytics and embedding analytics into applications. It allows engineers or analysts to query a data warehouse directly and visualize results. * **Tableau:** Often considered an industry standard for data visualization and business intelligence, offering extensive visualization capabilities. Tableau can connect to the dbt Semantic Layer. * **Microsoft Power BI:** A BI tool that integrates well within the Microsoft ecosystem, including Excel and Azure. Power BI can also use reports to query the dbt Semantic Layer. * **Google Looker Studio (formerly Google Data Studio):** A free, cloud-based data visualization tool with easy integrations across the Google ecosystem. * **Apache Superset:** An open-source BI platform that originated at Airbnb, offering advanced data analysis functionality and a broad range of visualization options. * **Mode Analytics:** A data science platform with BI capabilities, designed for data scientists and analysts. * **Lightdash:** Instantly turns your dbt project into a full-stack BI platform, allowing analysts to define metrics in dbt and enabling self-service for business users.

Citations

No citations found.

Raw meta json

{ "attempts": 1, "backoff_ms_total": 0, "grounding_enabled": true, "latency_ms": 10713, "model": "gemini-2.5-flash", "raw_response": { "automatic_function_calling_history": [], "candidates": [ { "avg_logprobs": null, "citation_metadata": null, "content": { "parts": [ { "code_execution_result": null, "executable_code": null, "file_data": null, "function_call": null, "function_response": null, "inline_data": null, "media_resolution": null, "text": "While dbt (data build tool) is primarily a data *transformation* tool that helps analytics engineers transform data in their warehouse using SQL, it\u0027s often a foundational component of a broader business intelligence (BI) stack. It brings software engineering practices like version control, testing, and documentation to data workflows.\n\nWhen looking for tools \"like dbt,\" you might be seeking:\n\n**1. Data Transformation Tools (Alternatives/Competitors to dbt):**\nThese tools also focus on preparing and modeling data, often using SQL or visual interfaces.\n* **SQL-based Transformation Tools:**\n * **Dataform:** Now part of Google Cloud, Dataform is a native SQL transformation tool similar to dbt, tightly integrated with BigQuery.\n * **SQLMesh:** An open-source Python framework that manages SQL file execution in DAG order and is backward compatible with dbt. It takes a declarative approach to building and managing SQL models.\n * **Coalesce:** A cloud-native transformation, catalog, and governance platform that offers a visual and modular development environment for both code-first SQL and GUI-driven workflows.\n* **Graphical ETL/ELT Tools (often with transformation capabilities):** These tools provide visual interfaces for building data pipelines, including transformation steps.\n * **Matillion:** A cloud-native ETL/ELT platform with a visual, low-code interface designed for cloud data warehouses, and it includes a native dbt Core component.\n * **Informatica:** An enterprise data integration platform with extensive ETL capabilities and data quality tooling.\n * **Talend (Qlik):** Known for its integration, data quality, and governance features, offering both open-source and enterprise solutions.\n * **Alteryx:** A self-service analytics and data preparation platform that offers a low-code approach, aimed at business users.\n * **AWS Glue:** A fully managed ETL service that handles infrastructure for data transformation.\n * **Azure Data Factory:** Microsoft\u0027s native orchestration service for cloud and hybrid data pipelines.\n* **Data Orchestration Tools (which can include transformation):**\n * **Apache Airflow:** An open-source tool for orchestrating data workflows using Python, often used to schedule and manage dbt jobs or custom ETL pipelines.\n * **Dagster:** A modern orchestration platform that offers Python-native workflows for complex pipelines and can run dbt models as part of broader workflows.\n\n**2. Business Intelligence (BI) Tools (which commonly integrate with dbt):**\nThese tools focus on data visualization, reporting, and dashboarding, consuming the transformed data from dbt or similar tools. Many BI tools seamlessly integrate with dbt to leverage its defined data models and metrics.\n\n* **Looker:** A powerful BI tool focused on data modeling using its proprietary language, LookerML, and is part of Google Cloud. It excels in governed, model-driven environments.\n* **Metabase:** An open-source BI platform known for its user-friendly interface for internal analytics and embedding analytics into applications. It allows engineers or analysts to query a data warehouse directly and visualize results.\n* **Tableau:** Often considered an industry standard for data visualization and business intelligence, offering extensive visualization capabilities. Tableau can connect to the dbt Semantic Layer.\n* **Microsoft Power BI:** A BI tool that integrates well within the Microsoft ecosystem, including Excel and Azure. Power BI can also use reports to query the dbt Semantic Layer.\n* **Google Looker Studio (formerly Google Data Studio):** A free, cloud-based data visualization tool with easy integrations across the Google ecosystem.\n* **Apache Superset:** An open-source BI platform that originated at Airbnb, offering advanced data analysis functionality and a broad range of visualization options.\n* **Mode Analytics:** A data science platform with BI capabilities, designed for data scientists and analysts.\n* **Lightdash:** Instantly turns your dbt project into a full-stack BI platform, allowing analysts to define metrics in dbt and enabling self-service for business users.", "thought": null, "thought_signature": null, "video_metadata": null } ], "role": "model" }, "finish_message": null, "finish_reason": "STOP", "grounding_metadata": { "google_maps_widget_context_token": null, "grounding_chunks": [ { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "matillion.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQGt8tNmj1yuc6JjqNhGlobDBY6GZ708tcBFTynOhlaKfnyQ71lUpIA9Bj5fhRhijFw7hTs7sBaqIkWgGiLxF4SnBytFDKokiRVwtNnaRtsS9hpnhTGyNMLuH0VWjafajyWUsSXrbKZR49rzIIIA4b0=" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "medium.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQGwownwJKzzrNtyUDrP3hZIcZKGHwaApbbCPrWMnqQyBC56FyehRNVwtiWHRYr8KyQxmjC8ICqeQerL9-PKMQChMxmANHAS8yLVC2r79wf_GTm1xVhs5-oJXqH65ub2-iQYwWDG3BiuP31uk760ns3I6j8EiIKsusJgFZXHVBsuYuaVPhZ5wtiVfmYv0E17W7vubYjjxu3MPvN_QpUZx9eN17AXJjEe70A=" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "estuary.dev", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQEgR1d9J7NQiLAXdca9s_X0CDHnHfzM2_uOQ8D34xzuVkMGVreJFw_3QQ4DYc5ZYBoEztCKrQaeRfBsHzJOGE8J-zFLAVMWsv34fmYH1naLDUudhQud0VBytZdVxmnzPNRIu374" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "getorchestra.io", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQGdHxMubJucOx6mNRTC8mxeUGpb6-UFUobgeon6BQiwF3GgeJpV4_4MHjhCxYWzErlyNBo_9zI5O1qdc3RQptmhghjaCcJ-pyg5OGkhF1VLMPQWLgGgzKbSAfZ_c39O-kBOxUNkCBPZSZ0DHeVFwg0BPbsIlys17ViNGpAI954LdTpc2bMEcaM20yHryNZgPmbRl1cQlsY=" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "greenmountaindatasolutions.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQGublnNZrLmHAvBisfcMRA-zSjAOVNvtylW-cYTFVSW5oGcdH1cKMI2AH10gVfgv5lWNUOfyJdFNk95w91oeL1OlltnHj5ofc6mn99YHOzmJdTCjrRF_J_De7vFWfkfWtDV9_eC4kaIO-Zja2tFc9uVO3JNFYlq_-uYFd120ukNcielhRvVywdlJfkrW8MN" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "coalesce.io", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQGZZQEkMoaMVCSqon6n5L2XmD-EEW73Bp0uCzb8XphlhxM_N_kud9ktZXXWx0DV8icGm_62cljFL6W7QSRW7vo9tI8HrmFUz3opbyQyVwdQqNPERZobtqiaMPVVXEjZIp9Jfk7jfnw7QGujT6nxNSusr3y7gEGr9dpECLiMhyr7er3PtToH0Gowo-6bfddHbSXdB1xWwsaUsqKL" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "gartner.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQGR5pzRSe_rmMWRgqhaieYtVw0zHtS2uNmatT14LfMPu_xgXdkqCOYFSAqoa65QMK84c3LJxSZR7nPUPHtSsg3AyBgvJC5hcvQNmM9OeFI04rQFLyMGpmXhEnVB6-k2CvXQDesfJGnqRrhltVXM8Zsbh0Dyld2pVuJFV7D9aKxufcqGIUV1iF9cGqgUkEJa9u70belM4CxDq1EXxYGN5nPdJr1rj1U=" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "datacoves.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQEzTehGFbcgryxdKdjIyrGU-QJCsxkbn-z9G-yFAV6COxQVw62Amrr5eXfKyBj_LN9R1-Cw0bRM446q3vhb4BPZ3WfGJGXeYRYYLNNOEaAQ2FITWc0db73nOtPaeP9ck--DH1liIg==" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "sourceforge.net", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQGSB132uqAfU06-_zABUz9-Whg4tLyd26wMYaUtWXJS8H2sxnF8-B4HDIqgkEHNd2L1P-z2rXIUhmrQ0yH3adoRHHR6fBjW1K1qCyK1u3BPH2eQW6r6_yufnbPOFJSwo2uhI3LmfAl0Dk6Pw8yvnghVpB0FvE8EVJHpeWLjpdbSyPo9hUjd" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "getdbt.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQE4IcmocamU_2yFguEkghej3PNbeGTXJn2tOwOZFpC0pOwWRNvuiJXG1A8nUzlOfQyVPpm-uuxPFX4DeO9G1u-_solypmOvDcuwCb7MVtTGdEEc0xw4Rw09XDLHdgHzm3q2ckT6w9_UsGHqYyVVnbqXxxgM8fPFyK6x748Bzl3c" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "getdbt.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQEIDb0SxHRvFzo43GOAcb8Amo47lOllKuq3yV6WCf2uYdpVZUPTLE7Yi385TkaMi6NfvedxCwhCu8sq_NEbz3JQgWNPDiCUecPN62lDPYbT4qzQAJ6WZK78oSdeCoXVh8ZGc6xpjA==" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "holistics.io", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQEPQX9vymxU0WHVA6LciCUhikWV3r9vhmIuQhEJ11kRoMgVl0J2v2s2EbESsft67meK_NOlqCtUQ4B3_KaqWq0EYTvfs6Ctg-v4ad3ElY7Q0r2-k9fBbtBP_pYc03AuY1U9oEk=" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "metabase.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQElQWYlIFZXjZQdKQ7VJiGQN9Id-c0ER-R10U7CzwzHs3AXR_238Cq2L_WDy4isVaiTrByRn3N1gqRVmS5BVPVAJ_6pY6b20djak6cuxmHoHE_KlgrSTSIx-h05CW1xvRb1xUkt_JI7BjEf3V6o" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "atlassian.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQF4vzP75qqoUZgFTZO6iLvImJO9HnHn48-o0MjuRotPUaJ1779PgWN7MX63st6wedI6_ZGUy4hmCdn6obbF5nVf6F0hccZKDim5WCSD-moMXWlbuFbIwzBOykAD3yl0Ky54eqzjLbN4u7uOKLqX3x6apskf8mEFX5KLYxn70c5B6hSkKgjf8iDnTVA=" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "chartio.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQHYkhWFQkVupZ3P7TDzHc3uD93SBb8AtOnCySFWCwDTTFcm5e5-mq-ICaqAEQ_n1flhTjn2pIWQ7ZRS_mV1cdzK5gAUXcjzHnOGIXlKfrZdr8xRIB18efWcBqY1BUabBbg_TPD-p_pl7vZxImDRlXaMTjcUJICRBPDnF7jnWUvMMa5axP735aaDTF9MDzSUoo1qd4ntnrx6" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "hoop.dev", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQFxO0pH_dYy_r5n2GLae6nH1K-2dRQ2jjtiPxp36vyNbZHPheM_oLzXqCkHWbjSVhIVWAM9cr7LedfeHdB96QhiKgX3Io1NlDyEml0hE72pGQlC9aVV2DH_JEFUdr_WXM8qTDGgwjxzatnOZ1OnousxAGX1xV695-uKzop8E8vRfyiS30Bo4yJpy7t3Og==" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "valiotti.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQFiU5EziS0ih_m6kPEoUC6q60IHaES4VS2LQrNneNuqTC_IkcAE8D_7t3biRz44LFDFqMuzdIsAVUu0j8Ty169i6Ax5immAGGI50MrJQpt9ddu20MnweUnUe8-JQOdcNdtdwnFMgwoT7mkrY5WY3h4yDK-L" } } ], "grounding_supports": [ { "confidence_scores": null, "grounding_chunk_indices": [ 0, 1 ], "segment": { "end_index": 227, "part_index": null, "start_index": null, "text": "While dbt (data build tool) is primarily a data *transformation* tool that helps analytics engineers transform data in their warehouse using SQL, it\u0027s often a foundational component of a broader business intelligence (BI) stack" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 0 ], "segment": { "end_index": 336, "part_index": null, "start_index": 229, "text": "It brings software engineering practices like version control, testing, and documentation to data workflows" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 2, 3 ], "segment": { "end_index": 739, "part_index": null, "start_index": 558, "text": "* **SQL-based Transformation Tools:**\n * **Dataform:** Now part of Google Cloud, Dataform is a native SQL transformation tool similar to dbt, tightly integrated with BigQuery" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 4 ], "segment": { "end_index": 874, "part_index": null, "start_index": 745, "text": "* **SQLMesh:** An open-source Python framework that manages SQL file execution in DAG order and is backward compatible with dbt" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 5 ], "segment": { "end_index": 943, "part_index": null, "start_index": 876, "text": "It takes a declarative approach to building and managing SQL models" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 5 ], "segment": { "end_index": 1136, "part_index": null, "start_index": 949, "text": "* **Coalesce:** A cloud-native transformation, catalog, and governance platform that offers a visual and modular development environment for both code-first SQL and GUI-driven workflows" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 0, 5 ], "segment": { "end_index": 1479, "part_index": null, "start_index": 1315, "text": "* **Matillion:** A cloud-native ETL/ELT platform with a visual, low-code interface designed for cloud data warehouses, and it includes a native dbt Core component" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 0, 6 ], "segment": { "end_index": 1602, "part_index": null, "start_index": 1485, "text": "* **Informatica:** An enterprise data integration platform with extensive ETL capabilities and data quality tooling" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 5 ], "segment": { "end_index": 1747, "part_index": null, "start_index": 1608, "text": "* **Talend (Qlik):** Known for its integration, data quality, and governance features, offering both open-source and enterprise solutions" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 5, 4 ], "segment": { "end_index": 1881, "part_index": null, "start_index": 1753, "text": "* **Alteryx:** A self-service analytics and data preparation platform that offers a low-code approach, aimed at business users" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 0 ], "segment": { "end_index": 1984, "part_index": null, "start_index": 1887, "text": "* **AWS Glue:** A fully managed ETL service that handles infrastructure for data transformation" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 5, 7 ], "segment": { "end_index": 2094, "part_index": null, "start_index": 1990, "text": "* **Azure Data Factory:** Microsoft\u0027s native orchestration service for cloud and hybrid data pipelines" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 2 ], "segment": { "end_index": 2326, "part_index": null, "start_index": 2096, "text": "* **Data Orchestration Tools (which can include transformation):**\n * **Apache Airflow:** An open-source tool for orchestrating data workflows using Python, often used to schedule and manage dbt jobs or custom ETL pipelines" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 2 ], "segment": { "end_index": 2490, "part_index": null, "start_index": 2332, "text": "* **Dagster:** A modern orchestration platform that offers Python-native workflows for complex pipelines and can run dbt models as part of broader workflows" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 8, 9, 10, 11 ], "segment": { "end_index": 2789, "part_index": null, "start_index": 2698, "text": "Many BI tools seamlessly integrate with dbt to leverage its defined data models and metrics" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 12, 13, 14 ], "segment": { "end_index": 2921, "part_index": null, "start_index": 2792, "text": "* **Looker:** A powerful BI tool focused on data modeling using its proprietary language, LookerML, and is part of Google Cloud" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 15 ], "segment": { "end_index": 2971, "part_index": null, "start_index": 2923, "text": "It excels in governed, model-driven environments" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 12, 16 ], "segment": { "end_index": 3120, "part_index": null, "start_index": 2973, "text": "* **Metabase:** An open-source BI platform known for its user-friendly interface for internal analytics and embedding analytics into applications" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 15 ], "segment": { "end_index": 3210, "part_index": null, "start_index": 3122, "text": "It allows engineers or analysts to query a data warehouse directly and visualize results" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 12, 16 ], "segment": { "end_index": 3362, "part_index": null, "start_index": 3212, "text": "* **Tableau:** Often considered an industry standard for data visualization and business intelligence, offering extensive visualization capabilities" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 9 ], "segment": { "end_index": 3409, "part_index": null, "start_index": 3364, "text": "Tableau can connect to the dbt Semantic Layer" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 12, 13, 16 ], "segment": { "end_index": 3527, "part_index": null, "start_index": 3411, "text": "* **Microsoft Power BI:** A BI tool that integrates well within the Microsoft ecosystem, including Excel and Azure" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 9 ], "segment": { "end_index": 3590, "part_index": null, "start_index": 3529, "text": "Power BI can also use reports to query the dbt Semantic Layer" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 13, 16 ], "segment": { "end_index": 3746, "part_index": null, "start_index": 3592, "text": "* **Google Looker Studio (formerly Google Data Studio):** A free, cloud-based data visualization tool with easy integrations across the Google ecosystem" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 12, 16 ], "segment": { "end_index": 3915, "part_index": null, "start_index": 3748, "text": "* **Apache Superset:** An open-source BI platform that originated at Airbnb, offering advanced data analysis functionality and a broad range of visualization options" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 13 ], "segment": { "end_index": 4028, "part_index": null, "start_index": 3917, "text": "* **Mode Analytics:** A data science platform with BI capabilities, designed for data scientists and analysts" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 8 ], "segment": { "end_index": 4200, "part_index": null, "start_index": 4030, "text": "* **Lightdash:** Instantly turns your dbt project into a full-stack BI platform, allowing analysts to define metrics in dbt and enabling self-service for business users" } } ], "retrieval_metadata": null, "retrieval_queries": null, "search_entry_point": { "rendered_content": "\u003cstyle\u003e\n.container {\n align-items: center;\n border-radius: 8px;\n display: flex;\n font-family: Google Sans, Roboto, sans-serif;\n font-size: 14px;\n line-height: 20px;\n padding: 8px 12px;\n}\n.chip {\n display: inline-block;\n border: solid 1px;\n border-radius: 16px;\n min-width: 14px;\n padding: 5px 16px;\n text-align: center;\n user-select: none;\n margin: 0 8px;\n -webkit-tap-highlight-color: transparent;\n}\n.carousel {\n overflow: auto;\n scrollbar-width: none;\n white-space: nowrap;\n margin-right: -12px;\n}\n.headline {\n display: flex;\n margin-right: 4px;\n}\n.gradient-container {\n position: relative;\n}\n.gradient {\n position: absolute;\n transform: translate(3px, -9px);\n height: 36px;\n width: 9px;\n}\n@media (prefers-color-scheme: light) {\n .container {\n background-color: #fafafa;\n box-shadow: 0 0 0 1px #0000000f;\n }\n .headline-label {\n color: #1f1f1f;\n }\n .chip {\n background-color: #ffffff;\n border-color: #d2d2d2;\n color: #5e5e5e;\n text-decoration: none;\n }\n .chip:hover {\n background-color: #f2f2f2;\n }\n .chip:focus {\n background-color: #f2f2f2;\n }\n .chip:active {\n background-color: #d8d8d8;\n border-color: #b6b6b6;\n }\n .logo-dark {\n display: none;\n }\n .gradient {\n background: linear-gradient(90deg, #fafafa 15%, #fafafa00 100%);\n }\n}\n@media (prefers-color-scheme: dark) {\n .container {\n background-color: #1f1f1f;\n box-shadow: 0 0 0 1px #ffffff26;\n }\n .headline-label {\n color: #fff;\n }\n .chip {\n background-color: #2c2c2c;\n border-color: #3c4043;\n color: #fff;\n text-decoration: none;\n }\n .chip:hover {\n background-color: #353536;\n }\n .chip:focus {\n background-color: #353536;\n }\n .chip:active {\n background-color: #464849;\n border-color: #53575b;\n }\n .logo-light {\n display: none;\n }\n .gradient {\n background: linear-gradient(90deg, #1f1f1f 15%, #1f1f1f00 100%);\n }\n}\n\u003c/style\u003e\n\u003cdiv class=\"container\"\u003e\n \u003cdiv class=\"headline\"\u003e\n \u003csvg class=\"logo-light\" width=\"18\" height=\"18\" viewBox=\"9 9 35 35\" fill=\"none\" xmlns=\"http://www.w3.org/2000/svg\"\u003e\n \u003cpath fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M42.8622 27.0064C42.8622 25.7839 42.7525 24.6084 42.5487 23.4799H26.3109V30.1568H35.5897C35.1821 32.3041 33.9596 34.1222 32.1258 35.3448V39.6864H37.7213C40.9814 36.677 42.8622 32.2571 42.8622 27.0064V27.0064Z\" fill=\"#4285F4\"/\u003e\n \u003cpath fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M26.3109 43.8555C30.9659 43.8555 34.8687 42.3195 37.7213 39.6863L32.1258 35.3447C30.5898 36.3792 28.6306 37.0061 26.3109 37.0061C21.8282 37.0061 18.0195 33.9811 16.6559 29.906H10.9194V34.3573C13.7563 39.9841 19.5712 43.8555 26.3109 43.8555V43.8555Z\" fill=\"#34A853\"/\u003e\n \u003cpath fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M16.6559 29.8904C16.3111 28.8559 16.1074 27.7588 16.1074 26.6146C16.1074 25.4704 16.3111 24.3733 16.6559 23.3388V18.8875H10.9194C9.74388 21.2072 9.06992 23.8247 9.06992 26.6146C9.06992 29.4045 9.74388 32.022 10.9194 34.3417L15.3864 30.8621L16.6559 29.8904V29.8904Z\" fill=\"#FBBC05\"/\u003e\n \u003cpath fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M26.3109 16.2386C28.85 16.2386 31.107 17.1164 32.9095 18.8091L37.8466 13.8719C34.853 11.082 30.9659 9.3736 26.3109 9.3736C19.5712 9.3736 13.7563 13.245 10.9194 18.8875L16.6559 23.3388C18.0195 19.2636 21.8282 16.2386 26.3109 16.2386V16.2386Z\" fill=\"#EA4335\"/\u003e\n \u003c/svg\u003e\n \u003csvg class=\"logo-dark\" width=\"18\" height=\"18\" viewBox=\"0 0 48 48\" xmlns=\"http://www.w3.org/2000/svg\"\u003e\n \u003ccircle cx=\"24\" cy=\"23\" fill=\"#FFF\" r=\"22\"/\u003e\n \u003cpath d=\"M33.76 34.26c2.75-2.56 4.49-6.37 4.49-11.26 0-.89-.08-1.84-.29-3H24.01v5.99h8.03c-.4 2.02-1.5 3.56-3.07 4.56v.75l3.91 2.97h.88z\" fill=\"#4285F4\"/\u003e\n \u003cpath d=\"M15.58 25.77A8.845 8.845 0 0 0 24 31.86c1.92 0 3.62-.46 4.97-1.31l4.79 3.71C31.14 36.7 27.65 38 24 38c-5.93 0-11.01-3.4-13.45-8.36l.17-1.01 4.06-2.85h.8z\" fill=\"#34A853\"/\u003e\n \u003cpath d=\"M15.59 20.21a8.864 8.864 0 0 0 0 5.58l-5.03 3.86c-.98-2-1.53-4.25-1.53-6.64 0-2.39.55-4.64 1.53-6.64l1-.22 3.81 2.98.22 1.08z\" fill=\"#FBBC05\"/\u003e\n \u003cpath d=\"M24 14.14c2.11 0 4.02.75 5.52 1.98l4.36-4.36C31.22 9.43 27.81 8 24 8c-5.93 0-11.01 3.4-13.45 8.36l5.03 3.85A8.86 8.86 0 0 1 24 14.14z\" fill=\"#EA4335\"/\u003e\n \u003c/svg\u003e\n \u003cdiv class=\"gradient-container\"\u003e\u003cdiv class=\"gradient\"\u003e\u003c/div\u003e\u003c/div\u003e\n \u003c/div\u003e\n \u003cdiv class=\"carousel\"\u003e\n \u003ca class=\"chip\" href=\"https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQExARrCnXLHFi6E5etpurC3EaTUIypqz0CBcrwcmw5KpopEYLmHKPYCpZreHNxQWLH_ED_k84DQIR_oF0Fxl8ixGM-tkzVuNH2BOgM4Pmarnl-0_UCJZVCngVas3mEPBkBBYF918IHmafQdGSubpA6UlZU7IxQEmwTTn7qt_OUnL1hEmyqseKsw3Vhn6xbYZm4BE01khnQR5-UjMRgRozjpyZF7q7t7b1KKx646NuVMGtkJJiFVnQ==\"\u003ebusiness intelligence tools that integrate with dbt\u003c/a\u003e\n \u003ca class=\"chip\" href=\"https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQHJJ-ht1ripcjRX0f10Kw98XEpi8mNfcpbnj6DzclVWDfyJ3Adajn2ngpMU2LNj7z6kIxHpdnHvLeQ3zMITL9xSC7YbquPNvrzXcNNLbWbDWYH3SvmMuS6srne487tpsNvh_yzWZycp6mbnXNXHOgrubfv7LLRvLw2DhTep8vb16gsz-Psg0RmSGYRCN3N8UpNKbejA-2qhOOp__Vdmi9BiZ92lsos=\"\u003edbt competitors data transformation\u003c/a\u003e\n \u003ca class=\"chip\" href=\"https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQHmDKqmgzjYx-NDruHRKAbSfvLc1nlee8EKARSTG95jRkn1UG8u5kjBxg162YRQm5t6pg8dWnc2nJVWuenVouBk9um4Bgp3BBov0FxTI3A0GCzBQbZ8m7ST2i23kdQ7DC24ekwPbZIhdemJsVVNiqPrfbSWWU5Dg2Upr7nA40DHZlnqjjFRrrX_tKa7fTrIZt3UOz7eIFuqlSNO-7M28BGvIvEyudFjhtDUMJVt\"\u003ebusiness intelligence tools similar to dbt\u003c/a\u003e\n \u003ca class=\"chip\" href=\"https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQHjX4HAgd3nVOUjVU16vA1ly3FnHqXDfBges1-mGUXNFEcZgAxxeNLbpy8ZJwfmN1znZdbxexyKIL5PG2tGKMP77AvS1rtFJBWAVkmC34qbdrRLgtinbg2aipG8IhlfqHJAkHJt1XOoX3CaGTUQFvlYgWcb5TW8YeuA8X9t3Ve-VwxWpvyuyVRQxER-pEemEiLk7Q==\"\u003edbt alternatives\u003c/a\u003e\n \u003ca class=\"chip\" href=\"https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQGAzK5qrg6ihz3drMJXb1x75NKTkR_1tTP594SZfnuXfxYn2GpZBFOUevmcvLfEkc4r-Chfg7iAlt8xFQ1Gj8D3SDbnJZwOmYakXmZDPk3D8beU2Mtg4ZDnY-C3cleoIisxwIgdaIONZEtRz6DRsC3cT9HOpU9gssPfGY_XAJNDZVCvRoXSVnqxrUyuZjQ-Ad12KwJH-VbOIAlcx1S7HWbzd7yR00C-eEAzsmfHUB7tteLehTqtprA=\"\u003ebusiness intelligence tools like looker and metabase\u003c/a\u003e\n \u003c/div\u003e\n\u003c/div\u003e\n", "sdk_blob": null }, "source_flagging_uris": null, "web_search_queries": [ "business intelligence tools similar to dbt", "dbt competitors data transformation", "dbt alternatives", "business intelligence tools that integrate with dbt", "business intelligence tools like looker and metabase" ] }, "index": 0, "logprobs_result": null, "safety_ratings": null, "token_count": null, "url_context_metadata": null } ], "create_time": null, "model_version": "gemini-2.5-flash", "parsed": null, "prompt_feedback": null, "response_id": "DWSMabeyCKa5xN8P-9DiqQM", "sdk_http_response": { "body": null, "headers": { "alt-svc": "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000", "content-encoding": "gzip", "content-type": "application/json; charset=UTF-8", "date": "Wed, 11 Feb 2026 11:12:13 GMT", "server": "scaffolding on HTTPServer2", "server-timing": "gfet4t7; dur=10474", "transfer-encoding": "chunked", "vary": "Origin, X-Origin, Referer", "x-content-type-options": "nosniff", "x-frame-options": "SAMEORIGIN", "x-xss-protection": "0" } }, "usage_metadata": { "cache_tokens_details": null, "cached_content_token_count": null, "candidates_token_count": 915, "candidates_tokens_details": null, "prompt_token_count": 77, "prompt_tokens_details": [ { "modality": "TEXT", "token_count": 77 } ], "thoughts_token_count": 528, "tool_use_prompt_token_count": 447, "tool_use_prompt_tokens_details": [ { "modality": "TEXT", "token_count": 447 } ], "total_token_count": 1967, "traffic_type": null } }, "request_payload": { "input": { "contents": "You are answering a user query. Be concise but helpful.\nIf you mention products or brands, be specific.\nDo not invent facts. If unsure, say you are unsure.\n\nBrand under analysis: Metabase\nBrand website: https://metabase.com\nEntity focus: competitor = looker\n\nUser query: What are some other business intelligence tools like DBT?", "model": "gemini-2.5-flash" }, "model": "gemini-2.5-flash", "provider": "gemini" }, "retry_policy": { "base_backoff_s": 0.6, "max_retries": 3, "timeout_s": 60 }, "usage": { "cost_usd": 0.0023106, "input_tokens": 77, "model": "gemini-2.5-flash", "output_tokens": 915, "pricing_source": "local_price_table_v1", "provider": "gemini", "total_tokens": 1967 }, "usage_raw": { "cache_tokens_details": null, "cached_content_token_count": null, "candidates_token_count": 915, "candidates_tokens_details": null, "prompt_token_count": 77, "prompt_tokens_details": [ { "modality": "TEXT", "token_count": 77 } ], "thoughts_token_count": 528, "tool_use_prompt_token_count": 447, "tool_use_prompt_tokens_details": [ { "modality": "TEXT", "token_count": 447 } ], "total_token_count": 1967, "traffic_type": null } }

What was sent to the model?

{ "input": { "contents": "You are answering a user query. Be concise but helpful.\nIf you mention products or brands, be specific.\nDo not invent facts. If unsure, say you are unsure.\n\nBrand under analysis: Metabase\nBrand website: https://metabase.com\nEntity focus: competitor = looker\n\nUser query: What are some other business intelligence tools like DBT?", "model": "gemini-2.5-flash" }, "model": "gemini-2.5-flash", "provider": "gemini" }

Error json

null