Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

*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.

```2022-03-25 01:46:43 [42mnormalization[0m &gt; 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 &gt; 01:46:43    002003 (42S02): SQL compilation error:
2022-03-25 01:46:43 [42mnormalization[0m &gt; 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 &gt; 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 &gt; 01:46:43  ```

Thanks for pointing that out <@U02TQLBLDU4>, 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 <@U036LQPNX08>, 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 (`_AIRBYTE_RAW_ORDER_SYRA_MIRROR`) . Could you re-run a sync and check what are the raw table are created? Feel free to continue this discussion on our <https://discuss.airbyte.io/|Discourse> forum as we're migrating the community support to this platform.