*Is this your first time deploying Airbyte*: Yes *...
# troubleshooting
Is this your first time deploying Airbyte: Yes OS Version / Instance: Windows Memory / Disk: 32Gb / 475GB SSD Deployment: Docker / Windows Local Airbyte Version: 0.35.39-alpha Source name/version: MySQL version 0.5.6 Destination name/version: Snowflake 0.4.22 Step: Initial Sync after creating connection Description: I'm trying to sync a single table from mysql with around 13m rows, failed 3 times. Logs appear to be showing that normalization failed.
Here is my log file
Copy code
2022-03-25 01:46:43 [42mnormalization[0m > 01:46:43  Database Error in model ORDER_SYRA_MIRROR (models/generated/airbyte_incremental/SYRA/ORDER_SYRA_MIRROR.sql)
2022-03-25 01:46:43 [42mnormalization[0m > 01:46:43    002003 (42S02): SQL compilation error:
2022-03-25 01:46:43 [42mnormalization[0m > 01:46:43    Object 'RAW.SYRA._AIRBYTE_RAW_ORDER_SYRA_MIRROR' does not exist or not authorized.
2022-03-25 01:46:43 [42mnormalization[0m > 01:46:43    compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/SYRA/ORDER_SYRA_MIRROR.sql
2022-03-25 01:46:43 [42mnormalization[0m > 01:46:43
Thanks for pointing that out @Marcos Marx (Airbyte), I stumbled on it too while trying to review logs. Since the data is technically moved to snowflake. can I trigger it somehow to just do normalization again without pulling data over again?
Also shouldn't be the table be auto generated?
airbyte didn't create _AIRBYTE_RAW_ORDER_SYRA_MIRROR tested connection and has privileges
Hi @Anton Escalante, the normalization runs directly on snowflake. Your problem here is that the normalization process is not able to read the raw table to normalize it (
) . Could you re-run a sync and check what are the raw table are created? Feel free to continue this discussion on our Discourse forum as we're migrating the community support to this platform.