hi all, i have a question about dbt and gooddata Is there a dbt Core adapter whose connection manager loads

com.gooddata.datawarehouse.jdbc.driver.DatawarehouseDriver

and connects to `jdbcgdc`<datawarehouse://...?> If not, is there a supported native Vertica endpoint for ADS, or would GoodData support or sponsor an ADS dbt adapter?

I'm sorry, but the provided knowledge sources do not contain information about: 1. Whether a dedicated dbt Core adapter exists that loads

com.gooddata.datawarehouse.jdbc.driver.DatawarehouseDriver

with the

jdbc:gdc:datawarehouse://...

URL format. 2. Whether there is a supported native Vertica endpoint for GoodData ADS. 3. Whether GoodData would support or sponsor an ADS dbt adapter. What is covered in the documentation: • GoodData ADS Data Source: GoodData ADS uses the connection format

jdbc:gdc:datawarehouse://<host>:<port>/gdc/datawarehouse/instances/<instanceId>

[GoodData ADS Source]. It is currently available as a beta data source in GoodData Cloud to connect legacy data warehouses [GoodData ADS Source]. • Native Vertica: GoodData Cloud natively supports connecting to Vertica (version 9.0+) via

jdbc:vertica://<host>:<port>/<databaseName>

[Vertica Source Details]. • GoodData-dbt Integration: GoodData provides a

gooddata-dbt

plugin (

pip install gooddata-dbt

) that reads dbt models and profiles to generate GoodData Logical Data Models (LDM) and deploy analytics, but this relies on supported dbt adapters and underlying data sources [gooddata-dbt Readme]. For specific questions regarding official sponsorship or roadmaps for an ADS-specific dbt adapter, please reach out directly to GoodData Support or your account representative. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups. 👀 Our Support team monitors all messages and will jump in if needed., with interactive elements

Hello Suhail, We noticed that you posted this question in the GoodData Cloud Slack community, while your question appears to be related to the GoodData Platform/Legacy product. Could you please share some additional details about your use case? This will help us better understand your needs and assist you more effectively.

Hi @Yvonne Changamuka thanks for the response So we actually use Gooddata Cloud in our company. We just the platform more as a orchestration tool. And we use ADS as the place where all the data is stored the reason I ask is because I am exploring dbt as a means to generate various sql scripts in differnt environments. right now we are manually maaintiaining all of these sql files and it gets hard to keep the region specific canges isolated. I am also exploring on building a medallion architecture for the data to make reporting easier Essentially I want to use dbt as a way to create and maintain views and tables. And I want to know if there is a way to have dbt run sql queries on the ads. does this make sense? thanks

Hello Suhail, Thank you for providing the additional context. I understand your use-case, particularly around using dbt to manage SQL transformations across different environments. At this time, however, ADS does not have a dbt adapter, and it is not possible to connect to the underlying Vertica database directly using the standard dbt Vertica adapter, as direct access to the Vertica database is not exposed. While dbt is not currently supported for ADS, GoodData provides its own transformation framework for ADS, including a SQL executor that can be used to run SQL transformations within ADS. Please let me know if this answers your question.

thanks @Yvonne Changamuka It does answer my question We do use the SQL executor already. It just isnt as flexible as something like dbt. It would be great if SQL Executor would be brought on par with dbt or create a dbt adapter for ADS thanks

@Suhail Mulla Hi, I Just wanted to inform you that we have submitted a product feedback on your behalf.

thanks @Julius Kos I really believe that having a first class and supported dbt adapter would really benefit the product. thank you so much! Please let me know if and when this gets implemented. thank you!

I would you suggest to Subscribe for updates in this case 🙂 gooddata.ai/docs/cloud/whats-new-cloud

thank you!