Hi, I’m trying to connect data from a MySQL 5.6.51...
# ask-community-for-troubleshooting
y
Hi, I’m trying to connect data from a MySQL 5.6.51 database to Snowflake using an Airbyte instance that someone else in my company set up, and I’m seeing a bunch of dbt errors during the load attempts.
Copy code
2022-07-18 18:58:08 normalization > 18:58:08  Database Error in model MRXW_LAV (models/generated/airbyte_tables/UMLS/MRXW_LAV.sql)
2022-07-18 18:58:08 normalization > 18:58:08    002003 (42S02): SQL compilation error:
2022-07-18 18:58:08 normalization > 18:58:08    Object 'UMLS_DATA_DEIDDEV.UMLS._AIRBYTE_RAW_MRXW_LAV' does not exist or not authorized.
2022-07-18 18:58:08 normalization > 18:58:08    compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_tables/UMLS/MRXW_LAV.sql
As these seem to be models that are set up by the connection at the top of the sync run, I’m not sure what’s needed or why they wouldn’t exist. The sync seems to be able to stage all of the data (using the internal “recommended” option), but fails as soon as it tries to transform that data into output to Snowflake. The data I’m trying to load includes some large tables (records in the hundreds of millions), and one of the questions I had was whether the recommended option could support staging that much data? Or if there’s some other pattern that I might be missing for ensuring that the sync can run to completion. Thanks!