[Bug] Quickstart missing CountryCodes Seed

[bassrock]

Is there an existing issue for this?

• [X] I have searched the existing issues

Describe the issue

It seems that the quickstart model when used in Fivetran is not seeding the app_store_source table seeds that are required by this package.

Relevant error log or model output

bt run --select +apple_store__territory_report --full-refresh
15:07:22
Running with dbt=1.7.9
15:07:23
Registered adapter: snowflake=1.7.2
15:07:23
Unable to do partial parsing because saved manifest not found. Starting full parse.
15:07:27
Found 53 models, 1 seed, 23 tests, 16 sources, 0 exposures, 0 metrics, 679 macros, 0 groups, 0 semantic models
15:07:27
15:07:29
Concurrency: 4 threads (target='prod')
15:07:29
15:07:29
1 of 9 START sql view model apple_app_store_apple_store_source.stg_apple_store__app_store_territory_tmp [RUN]
15:07:29
2 of 9 START sql view model apple_app_store_apple_store_source.stg_apple_store__app_tmp [RUN]
15:07:29
3 of 9 START sql view model apple_app_store_apple_store_source.stg_apple_store__downloads_territory_tmp [RUN]
15:07:29
4 of 9 START sql view model apple_app_store_apple_store_source.stg_apple_store__usage_territory_tmp [RUN]
15:07:30
3 of 9 OK created sql view model apple_app_store_apple_store_source.stg_apple_store__downloads_territory_tmp [SUCCESS 1 in 1.26s]
15:07:30
5 of 9 START sql table model apple_app_store_apple_store_source.stg_apple_store__downloads_territory [RUN]
15:07:30
4 of 9 OK created sql view model apple_app_store_apple_store_source.stg_apple_store__usage_territory_tmp [SUCCESS 1 in 1.28s]
15:07:30
6 of 9 START sql table model apple_app_store_apple_store_source.stg_apple_store__usage_territory [RUN]
15:07:30
2 of 9 OK created sql view model apple_app_store_apple_store_source.stg_apple_store__app_tmp [SUCCESS 1 in 1.40s]
15:07:31
7 of 9 START sql table model apple_app_store_apple_store_source.stg_apple_store__app [RUN]
15:07:31
1 of 9 OK created sql view model apple_app_store_apple_store_source.stg_apple_store__app_store_territory_tmp [SUCCESS 1 in 1.71s]
15:07:31
8 of 9 START sql table model apple_app_store_apple_store_source.stg_apple_store__app_store_territory [RUN]
15:07:33
7 of 9 OK created sql table model apple_app_store_apple_store_source.stg_apple_store__app [SUCCESS 1 in 2.45s]
15:07:35
5 of 9 OK created sql table model apple_app_store_apple_store_source.stg_apple_store__downloads_territory [SUCCESS 1 in 4.88s]
15:07:36
6 of 9 OK created sql table model apple_app_store_apple_store_source.stg_apple_store__usage_territory [SUCCESS 1 in 5.12s]
15:07:36
8 of 9 OK created sql table model apple_app_store_apple_store_source.stg_apple_store__app_store_territory [SUCCESS 1 in 4.88s]
15:07:36
9 of 9 START sql table model apple_app_store_apple_store.apple_store__territory_report [RUN]
15:07:36
9 of 9 ERROR creating sql table model apple_app_store_apple_store.apple_store__territory_report [ERROR in 0.57s]
15:07:36
15:07:36
Finished running 4 view models, 5 table models in 0 hours 0 minutes and 9.10 seconds (9.10s).
15:07:36
15:07:36
Completed with 1 error and 0 warnings:
15:07:36
15:07:36
Database Error in model apple_store__territory_report (models/apple_store__territory_report.sql)
002003 (42S02): SQL compilation error:
Object 'FIVETRAN.APPLE_APP_STORE_APPLE_STORE_SOURCE.APPLE_STORE_COUNTRY_CODES' does not exist or not authorized.
compiled Code at target/run/apple_store/models/apple_store__territory_report.sql

Expected behavior

The run to succeed and seed the tables it needs

dbt Project configurations

N/A Using fivetran quickstart transformations

Package versions

0.3.2

What database are you using dbt with?

snowflake

dbt Version

1.7.9

Additional Context

No response

Are you willing to open a PR to help address this issue?

• [X] Yes.
• [ ] Yes, but I will need assistance and will schedule time during our office hours for guidance
• [ ] No.

[fivetran-catfritz]

Hi @bassrock I was able to see this failure you mentioned, but interestingly I also see there recently was a successful run. I'm going to keep this ticket open for a bit in case it was a blip, so let me know if the issue persists or is resolved!

[bassrock]

If you looked at the account this was in, that was because we manually copied the table over as it was blocking us.

[fivetran-catfritz]

Oh got it thanks for clearing that up. I was suspicious it suddenly started working. I'll bring this up with the engineering team then!

[fivetran-catfritz]

Hi @bassrock thanks again for flagging this issue. An update has been released in Quickstart that should address this issue. Since you have already manually added the table, you will not need to do anything, but I wanted to let you know that the update was available if ever necessary. I'm going to close this issue, but if you need to reach us again, just ping us in this ticket!