We have our legacy Data Warehouse in Postgres and we are having the DDLs and the analytic queries in the legacy repository.
legacy_repo
- sql
-
- ddls
-
- analytic_queries
We want Cursor to assist us with migrating the analytic queries (the SELECT statements) into dbt models that can be executed on our new Snowflake Data Warehouse.
The Snowflake DWH has ingested all the source data that is needed for the analytic queries already, but schema names, table names and field names are slightly different from the legacy DWH. We have a dbt_repo with all the models for the source data:
dtb_repo
- models
-
- layer1
-
-
- zendesk (parsing JSON zendesk data from layer0 into flattened tables)
-
Cursor should assist us in creating analytic queries for layer2. These queries would be based on tables in layer1.
I am new to Cursor and I found out how to open a git repo in Cursor. But I am not sure how to set it up with 2 repos where 1 should be the source and 1 the target.
Any advices?