Ai visibility local
Local only

Run item

gemini · Metabase · question_index=2

Question

What are some comparable tools to dbt in the analytics space?

Answer

Metabase users looking for comparable tools to dbt (data build tool) in the analytics space have several options that focus on data transformation and modeling, often employing software engineering best practices within the data stack. These tools can generally be categorized into code-first transformation engines and more comprehensive ETL/ELT platforms with strong transformation capabilities. **Code-First Data Transformation Tools:** * **Dataform (Google Cloud Dataform)**: Often described as a close alternative to dbt, Dataform is a SQL-based data transformation tool tightly integrated with Google BigQuery. It enables modular SQL-based pipelines, dependency management, and scheduling within a web interface. * **SQLMesh (Fivetran)**: Recently acquired by Fivetran, SQLMesh is an open-source framework for SQL- and Python-based data transformations. It emphasizes scalability and predictability, offering a declarative approach, built-in testing, and environment management. It can also inspect SQL to determine dependencies without explicit macros. * **Coalesce**: A cloud-native transformation, catalog, and governance platform, Coalesce provides a visual and modular development environment that supports both code-first SQL users and GUI-driven workflows. It's often chosen by teams that have outgrown dbt's governance model. * **Datacoves**: This platform manages a full open-source data stack, including dbt, Airflow, and VS Code, offering a flexible and secure alternative to dbt Cloud with built-in orchestration. **ETL/ELT Platforms with Data Transformation Capabilities:** * **Matillion**: A cloud-native ETL/ELT platform with a visual interface, Matillion supports warehouse-native transformations and can incorporate dbt workflows. It offers a low-code, drag-and-drop interface for pipeline design while also allowing custom SQL or Python scripts for complex tasks. * **Talend (Qlik)**: Known for its data integration, quality, and governance features, Talend provides a comprehensive suite of transformation capabilities with a visual interface, bridging legacy and cloud environments. * **Informatica**: An enterprise-grade data integration platform, Informatica offers extensive ETL capabilities, a wide range of connectors, data quality tools, and advanced security features. * **Azure Data Factory (ADF)**: Microsoft's cloud-based data integration service provides broad functionalities for data movement and transformation across various environments. It excels at connecting to numerous on-premises and cloud data sources. * **Alteryx**: This self-service analytics and data preparation platform is more than just transformations, offering an end-to-end solution for business users with a low-code approach. * **Fivetran**: Primarily an ELT tool focused on automated data movement, Fivetran also supports post-load transformations and offers native integration with dbt Core, allowing users to manage ingestion and transformation within a unified platform. * **Hevo Data**: An ELT platform that streamlines data pipelines and transformations. * **AWS Glue**: A serverless data integration service that supports Python-based ETL and transformation workflows within the AWS ecosystem. * **SQL Server Integration Services (SSIS)**: A versatile ETL tool from Microsoft that provides a comprehensive suite for data extraction, transformation, and loading, especially strong in scenarios with diverse data sources. **Orchestration Tools (can manage dbt or custom transformations):** * **Apache Airflow**: An open-source platform for orchestrating complex data workflows, Airflow is widely used to schedule and manage dbt jobs or as a foundation for custom ETL pipelines, ideal for complex task dependencies and full pipeline control. * **Dagster**: A data orchestration and transformation framework. * **Prefect**: An orchestration framework that can include Python or SQL transformation steps. * **Orchestra**: A control plane for data workflows with dbt orchestration, offering a scalable compute engine, observability, and metadata. **Other notable tools:** * **Quadratic**: An online data transformation tool that offers a no-code interface with the flexibility to write Python code for personalized transformations. It also supports data analysis and visualization. The choice of a dbt alternative often depends on a team's existing skill set, governance requirements, preferred cloud platform, and whether they prioritize a code-first, visual, or hybrid approach to data transformation.

Citations

No citations found.

Raw meta json

{ "attempts": 1, "backoff_ms_total": 0, "grounding_enabled": true, "latency_ms": 9228, "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": "Metabase users looking for comparable tools to dbt (data build tool) in the analytics space have several options that focus on data transformation and modeling, often employing software engineering best practices within the data stack. These tools can generally be categorized into code-first transformation engines and more comprehensive ETL/ELT platforms with strong transformation capabilities.\n\n**Code-First Data Transformation Tools:**\n\n* **Dataform (Google Cloud Dataform)**: Often described as a close alternative to dbt, Dataform is a SQL-based data transformation tool tightly integrated with Google BigQuery. It enables modular SQL-based pipelines, dependency management, and scheduling within a web interface.\n* **SQLMesh (Fivetran)**: Recently acquired by Fivetran, SQLMesh is an open-source framework for SQL- and Python-based data transformations. It emphasizes scalability and predictability, offering a declarative approach, built-in testing, and environment management. It can also inspect SQL to determine dependencies without explicit macros.\n* **Coalesce**: A cloud-native transformation, catalog, and governance platform, Coalesce provides a visual and modular development environment that supports both code-first SQL users and GUI-driven workflows. It\u0027s often chosen by teams that have outgrown dbt\u0027s governance model.\n* **Datacoves**: This platform manages a full open-source data stack, including dbt, Airflow, and VS Code, offering a flexible and secure alternative to dbt Cloud with built-in orchestration.\n\n**ETL/ELT Platforms with Data Transformation Capabilities:**\n\n* **Matillion**: A cloud-native ETL/ELT platform with a visual interface, Matillion supports warehouse-native transformations and can incorporate dbt workflows. It offers a low-code, drag-and-drop interface for pipeline design while also allowing custom SQL or Python scripts for complex tasks.\n* **Talend (Qlik)**: Known for its data integration, quality, and governance features, Talend provides a comprehensive suite of transformation capabilities with a visual interface, bridging legacy and cloud environments.\n* **Informatica**: An enterprise-grade data integration platform, Informatica offers extensive ETL capabilities, a wide range of connectors, data quality tools, and advanced security features.\n* **Azure Data Factory (ADF)**: Microsoft\u0027s cloud-based data integration service provides broad functionalities for data movement and transformation across various environments. It excels at connecting to numerous on-premises and cloud data sources.\n* **Alteryx**: This self-service analytics and data preparation platform is more than just transformations, offering an end-to-end solution for business users with a low-code approach.\n* **Fivetran**: Primarily an ELT tool focused on automated data movement, Fivetran also supports post-load transformations and offers native integration with dbt Core, allowing users to manage ingestion and transformation within a unified platform.\n* **Hevo Data**: An ELT platform that streamlines data pipelines and transformations.\n* **AWS Glue**: A serverless data integration service that supports Python-based ETL and transformation workflows within the AWS ecosystem.\n* **SQL Server Integration Services (SSIS)**: A versatile ETL tool from Microsoft that provides a comprehensive suite for data extraction, transformation, and loading, especially strong in scenarios with diverse data sources.\n\n**Orchestration Tools (can manage dbt or custom transformations):**\n\n* **Apache Airflow**: An open-source platform for orchestrating complex data workflows, Airflow is widely used to schedule and manage dbt jobs or as a foundation for custom ETL pipelines, ideal for complex task dependencies and full pipeline control.\n* **Dagster**: A data orchestration and transformation framework.\n* **Prefect**: An orchestration framework that can include Python or SQL transformation steps.\n* **Orchestra**: A control plane for data workflows with dbt orchestration, offering a scalable compute engine, observability, and metadata.\n\n**Other notable tools:**\n\n* **Quadratic**: An online data transformation tool that offers a no-code interface with the flexibility to write Python code for personalized transformations. It also supports data analysis and visualization.\n\nThe choice of a dbt alternative often depends on a team\u0027s existing skill set, governance requirements, preferred cloud platform, and whether they prioritize a code-first, visual, or hybrid approach to data transformation.", "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": "estuary.dev", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQGpwkXi9GcsIRtWnXs3cGVGQDVoenWDmRNsJFFNbS6Nn9alMLH_qPr1wSRDgX7KjBFrAtvYBm-DlNMX8jfk2zdKPe6g51VWJNm2L_p-9-quoGgg4ZLC5T8SJ98aSOZeRFEP761lHg==" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "coalesce.io", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQEPzqKRJu8ag2zvTiZSSHwmcLCe55Cno9kyILixRmDHsn77MnNnk1ftCAILgVaSDxo8O7UPycSnXKeg5CyAC763RRh2lkCoeSARV1VcpNX3Grd4pzJFEQ2e2SyE2Xqk4Z-ZO6Ug4ch980KysQbvpx6h5sjBlOd-xKcsu2ouJ3JxWNVBm8NwrQE0Hn1kaTaTXd7T-dl2szpmIbHmVQ==" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "greenmountaindatasolutions.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQFxs8_sDzocxwCIlPgzfbZo51FazwCtRjGqqGtQoy7dgwdoFB1tCJ0TsCnlp8DlAZ-aPinaLHVqAGCAbRrWhE8BekywmsQWO6LHnfEoCx9VeLnTzzKGjVtTjkJqS1hOzuIsRAfCX4K9kpHkDEm1WIdP8ijUYNRM_s6X64huZrqLpUkqDahMWDLrqjjkaXGYqg==" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "datacoves.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQH_f5EfAMl4ZIQD7ipCYqbGqRC8f9wskonSVOBiSzvCV6qApj3EQSCS_sV3gzcTcILcOXDfw-17TpAJjx1xPkSGhjjY76aSdqummg1S72tfrHfZudITDmfIuwT57bnYib9eV07W-Ug=" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "matillion.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQEq34dYuVcBUz6NwCHtHh-fCIXHM0kQ9yBuSDu8R7MP4J8-qTTgWihGe4GNsP1zM02WlBkS-JqL8EOcLJy5ZrVEDAs_dxyrJHso66nIkC_p7VE9Ydbjco6bquUG5mAHsAX-cmXBEXLcsZpqoV-mFIdB" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "quadratichq.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQFwMkX_mBiuZG1bVC7jF8Zqz6lsFRqHRGn1vYJgs0hmtcs1Z0kLgTArvOO8GX6o2YI314uMyiDvB8KmxeisKYWsJhT1HLd1Rjdqg5ojP-v2gy29HINzHSVeppCTd-DIC22pE0r1SCE9pn8aDoVOUlweTunHpigcbb00X2cWSAgf75jC62xjM245KoQ=" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "getelyxai.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQF200wsYkGQ8LmfhbgNLMehch60-ze9fPuue07UIRLA6gY295u2ve-TjRcWKesLU5OyC9VAS_WuZ1Gj-wVW6UoPUoUP6LlS4t-0q1gdCX6LXMSBZSuh-Ad_Kx52rLWCq16cNRFMSvzOhXeqYnqgPqhcFt9z0tQYfw==" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "superblocks.com", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQHPW22BvELfdGct9iiZ8g9BavCILnwBX9AQCW9bnboBpadOYrsu440NATtCqykNQnME_PhzQgMTyoRfufgaH_cuUbBQy5-fP2soiscVRaER3SpMfTCIpIbgPvhSLlU8mnscgsm_fky93baqjJiZj5iWgzDmgdc=" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "getorchestra.io", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQHgLzmVHufBNYi4J6TqQrJI7JdVDztsfTogKRGCsg9eNHpteUS0S--xF55FuHJdXW7OP9QNRFap0SKC3pdiz2-UJExrcXJTa49qVu1FpT9rSUFib98n6gN1xgHghPCRCmLfapBjH3jznOnES2D7MdKjjB-thlVoujo29Q6dGeqs9-CpnQIM4un2xWpel_NWeOAka9Bz" } }, { "maps": null, "retrieved_context": null, "web": { "domain": null, "title": "integrate.io", "uri": "https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQFVJFd5ufnJT-_6Wy4Ny90Km-hrUfp8wn6kxgjH9-wNVYIMixjrQyJy71zKFjvX4tUVz82BC8l8wcWYu7qu45D-f3olF2dhj-4c1TyrpQZRWxJl3Yra6CBCMTzecRxceNirNgWt9CRvTmcY-Y-e2BSQ2L-56OfIgQ==" } } ], "grounding_supports": [ { "confidence_scores": null, "grounding_chunk_indices": [ 0 ], "segment": { "end_index": 721, "part_index": null, "start_index": 621, "text": "It enables modular SQL-based pipelines, dependency management, and scheduling within a web interface" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 1, 2, 3 ], "segment": { "end_index": 1064, "part_index": null, "start_index": 991, "text": "It can also inspect SQL to determine dependencies without explicit macros" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 1 ], "segment": { "end_index": 1346, "part_index": null, "start_index": 1278, "text": "It\u0027s often chosen by teams that have outgrown dbt\u0027s governance model" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 1, 2, 3 ], "segment": { "end_index": 1540, "part_index": null, "start_index": 1348, "text": "* **Datacoves**: This platform manages a full open-source data stack, including dbt, Airflow, and VS Code, offering a flexible and secure alternative to dbt Cloud with built-in orchestration" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 1, 4, 5, 6, 7 ], "segment": { "end_index": 1900, "part_index": null, "start_index": 1768, "text": "It offers a low-code, drag-and-drop interface for pipeline design while also allowing custom SQL or Python scripts for complex tasks" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 1, 4, 3, 8, 9 ], "segment": { "end_index": 2123, "part_index": null, "start_index": 1902, "text": "* **Talend (Qlik)**: Known for its data integration, quality, and governance features, Talend provides a comprehensive suite of transformation capabilities with a visual interface, bridging legacy and cloud environments" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 1, 3, 6 ], "segment": { "end_index": 2318, "part_index": null, "start_index": 2125, "text": "* **Informatica**: An enterprise-grade data integration platform, Informatica offers extensive ETL capabilities, a wide range of connectors, data quality tools, and advanced security features" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 1, 2, 3, 6 ], "segment": { "end_index": 2570, "part_index": null, "start_index": 2500, "text": "It excels at connecting to numerous on-premises and cloud data sources" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 1, 2, 3 ], "segment": { "end_index": 2757, "part_index": null, "start_index": 2572, "text": "* **Alteryx**: This self-service analytics and data preparation platform is more than just transformations, offering an end-to-end solution for business users with a low-code approach" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 4, 9, 6, 7 ], "segment": { "end_index": 3008, "part_index": null, "start_index": 2759, "text": "* **Fivetran**: Primarily an ELT tool focused on automated data movement, Fivetran also supports post-load transformations and offers native integration with dbt Core, allowing users to manage ingestion and transformation within a unified platform" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 1, 9 ], "segment": { "end_index": 3096, "part_index": null, "start_index": 3010, "text": "* **Hevo Data**: An ELT platform that streamlines data pipelines and transformations" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 1, 3, 6 ], "segment": { "end_index": 3238, "part_index": null, "start_index": 3098, "text": "* **AWS Glue**: A serverless data integration service that supports Python-based ETL and transformation workflows within the AWS ecosystem" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 2, 3 ], "segment": { "end_index": 3466, "part_index": null, "start_index": 3240, "text": "* **SQL Server Integration Services (SSIS)**: A versatile ETL tool from Microsoft that provides a comprehensive suite for data extraction, transformation, and loading, especially strong in scenarios with diverse data sources" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 0, 8 ], "segment": { "end_index": 3789, "part_index": null, "start_index": 3538, "text": "* **Apache Airflow**: An open-source platform for orchestrating complex data workflows, Airflow is widely used to schedule and manage dbt jobs or as a foundation for custom ETL pipelines, ideal for complex task dependencies and full pipeline control" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 0 ], "segment": { "end_index": 3857, "part_index": null, "start_index": 3791, "text": "* **Dagster**: A data orchestration and transformation framework" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 1 ], "segment": { "end_index": 3954, "part_index": null, "start_index": 3859, "text": "* **Prefect**: An orchestration framework that can include Python or SQL transformation steps" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 0, 2 ], "segment": { "end_index": 4097, "part_index": null, "start_index": 3956, "text": "* **Orchestra**: A control plane for data workflows with dbt orchestration, offering a scalable compute engine, observability, and metadata" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 5 ], "segment": { "end_index": 4336, "part_index": null, "start_index": 4288, "text": "It also supports data analysis and visualization" } }, { "confidence_scores": null, "grounding_chunk_indices": [ 1, 3 ], "segment": { "end_index": 4559, "part_index": null, "start_index": 4339, "text": "The choice of a dbt alternative often depends on a team\u0027s existing skill set, governance requirements, preferred cloud platform, and whether they prioritize a code-first, visual, or hybrid approach to data transformation" } } ], "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/AUZIYQGHFo52xGo_Zbzyv0U4cQaR6G3wNMcBI_y3szppejihcw5SzyMciMe21r3xnFHjl1F_-vyaIWacoU8TGx_92O8-uiPjT_7O5Faii-tDSbGGKlApGch9F59sCRLuzE-OoItHXZi-n44HnaPJs924QllXB-FP_-_EdantY-eWIxi__-V5gpnKALAb8YtAENz1pMxlKrsye4bYvnLKc50Rnk71Kx09Zd_kLIlzMo6u108L\"\u003edata transformation tools alternative to dbt\u003c/a\u003e\n \u003ca class=\"chip\" href=\"https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQFunJIGJf_IUtRhB1iokVXSS-yVFVLY5-OTdKVyuhjaLSO6xUQ855ckTVjb_7YLWKzpQJEJxd7c1NCsaoFteJC0DAKvMlOHn_7Ol3zzQ1Bf4-cK41qCymF-uo7993Z7FE_O8e6-ZbVdKHxTRxIp7LRRAt-S9hEHf897GzYNy74yVO8H1cG4q64nw9PZjslL9p92eRxYzkEFxXI9IGnDN01f-CQnF-1qFQ==\"\u003edbt comparable tools analytics space\u003c/a\u003e\n \u003ca class=\"chip\" href=\"https://vertexaisearch.cloud.google.com/grounding-api-redirect/AUZIYQFqEjAyye6cbFGhOAD4uFUI7MGfTyxOwAkjzfrHvzoaidaJfw2EopfyYuElv5g319n7k0Su2Dmb3rPqNL3AP8OUaHD2D4myUe0fWP4b92umDAVyPgAzLo4Kq9yYlwdRygV21B3n8PF5YI_S5skb_0Bo5vx9CemJ-d_ku-2QhC0n1o__F-nCvWQGm8FRIX6Qd2sG03yYGkjtJrc9iVGpCNMnXi2DPXKKT1wmI_a1bsBeEmDzQ51xAok=\"\u003etools for data transformation and modeling like dbt\u003c/a\u003e\n \u003c/div\u003e\n\u003c/div\u003e\n", "sdk_blob": null }, "source_flagging_uris": null, "web_search_queries": [ "dbt comparable tools analytics space", "tools for data transformation and modeling like dbt", "data transformation tools alternative to dbt" ] }, "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": "wmSMaf-TFPP4kdUP-9-NyAk", "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:15:14 GMT", "server": "scaffolding on HTTPServer2", "server-timing": "gfet4t7; dur=8980", "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": 945, "candidates_tokens_details": null, "prompt_token_count": 72, "prompt_tokens_details": [ { "modality": "TEXT", "token_count": 72 } ], "thoughts_token_count": 287, "tool_use_prompt_token_count": 183, "tool_use_prompt_tokens_details": [ { "modality": "TEXT", "token_count": 183 } ], "total_token_count": 1487, "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\n\nUser query: What are some comparable tools to dbt in the analytics space?", "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.0023841, "input_tokens": 72, "model": "gemini-2.5-flash", "output_tokens": 945, "pricing_source": "local_price_table_v1", "provider": "gemini", "total_tokens": 1487 }, "usage_raw": { "cache_tokens_details": null, "cached_content_token_count": null, "candidates_token_count": 945, "candidates_tokens_details": null, "prompt_token_count": 72, "prompt_tokens_details": [ { "modality": "TEXT", "token_count": 72 } ], "thoughts_token_count": 287, "tool_use_prompt_token_count": 183, "tool_use_prompt_tokens_details": [ { "modality": "TEXT", "token_count": 183 } ], "total_token_count": 1487, "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\n\nUser query: What are some comparable tools to dbt in the analytics space?", "model": "gemini-2.5-flash" }, "model": "gemini-2.5-flash", "provider": "gemini" }

Error json

null