https://linen.dev logo
#plugins-general
Title
# plugins-general
o

ofer_kulka

12/03/2020, 6:30 PM
```target-snowflake | INFO MillisLoggingCursor: 71 millis spent executing: \n SELECT COUNT(1) FROM "X"."Y"."ADS_INSIGHTS__UNIQUE_ACTIONS" \n target-snowflake | INFO METRIC: {"type": "timer", "metric": "job_duration", "value": 2.766920804977417, "tags": {"job_type": "upsert_table_schema", "path": ["ads_insights", "unique_actions"], "warehouse": "MAIN", "database": "X", "schema": "Y", "table": "ADS_INSIGHTS__UNIQUE_ACTIONS", "status": "failed"}} target-snowflake | INFO METRIC: {"type": "counter", "metric": "record_count", "value": 0, "tags": {"count_type": "table_rows_persisted", "path": ["ads_insights", "unique_actions"], "warehouse": "MAIN", "database": "X", "schema": "Y"}} target-snowflake | INFO METRIC: {"type": "timer", "metric": "job_duration", "value": 2.769408702850342, "tags": {"job_type": "table", "path": ["ads_insights", "unique_actions"], "warehouse": "MAIN", "database": "X", "schema": "Y", "status": "failed"}} target-snowflake | INFO METRIC: {"type": "counter", "metric": "record_count", "value": 28, "tags": {"count_type": "batch_rows_persisted", "path": ["ads_insights"], "warehouse": "MAIN", "database": "X", "schema": "Y"}} target-snowflake | INFO METRIC: {"type": "timer", "metric": "job_duration", "value": 30.653257846832275, "tags": {"job_type": "batch", "path": ["ads_insights"], "warehouse": "MAIN", "database": "X", "schema": "Y", "status": "failed"}} target-snowflake | INFO MillisLoggingCursor: 51 millis spent executing: ROLLBACK target-snowflake | ERROR Exception writing records target-snowflake | Traceback (most recent call last): target-snowflake | File "/project/.meltano/loaders/target-snowflake/venv/lib/python3.6/site-packages/target_snowflake/snowflake.py", line 155, in write_batch target-snowflake | {'version': target_table_version}) target-snowflake | File "/project/.meltano/loaders/target-snowflake/venv/lib/python3.6/site-packages/target_postgres/sql_base.py", line 824, in write_batch_helper target-snowflake | metadata) target-snowflake | File "/project/.meltano/loaders/target-snowflake/venv/lib/python3.6/site-packages/target_postgres/sql_base.py", line 463, in upsert_table_helper target-snowflake | column_schema) target-snowflake | File "/project/.meltano/loaders/target-snowflake/venv/lib/python3.6/site-packages/target_snowflake/snowflake.py", line 555, in add_column target-snowflake | column_name=sql.identifier(column_name), target-snowflake | File "/project/.meltano/loaders/target-snowflake/venv/lib/python3.6/site-packages/target_snowflake/sql.py", line 36, in identifier target-snowflake | valid_identifier(x) target-snowflake | File "/project/.meltano/loaders/target-snowflake/venv/lib/python3.6/site-packages/target_snowflake/sql.py", line 29, in valid_identifier target-snowflake | x target-snowflake | target_snowflake.exceptions.SQLError: Identifier must only contain alphanumerics, or underscores, and start with alphas. Got
a
for
1D_CLICK
target-snowflake | CRITICAL ('Exception writing records', SQLError('Identifier must only contain alphanumerics, or underscores, and start with alphas. Got
a
for `1D_CLICK`',)) target-snowflake | INFO MillisLoggingCursor: 47 millis spent executing: ROLLBACK target-snowflake | Traceback (most recent call last): target-snowflake | File "/project/.meltano/loaders/target-snowflake/venv/lib/python3.6/site-packages/target_snowflake/snowflake.py", line 155, in write_batch target-snowflake | {'version': target_table_version}) target-snowflake | File "/project/.meltano/loaders/target-snowflake/venv/lib/python3.6/site-packages/target_postgres/sql_base.py", line 824, in write_batch_helper target-snowflake | metadata) target-snowflake | File "/project/.meltano/loaders/target-snowflake/venv/lib/python3.6/site-packages/target_postgres/sql_base.py", line 463, in upsert_table_helper target-snowflake | column_schema) target-snowflake | File "/project/.meltano/loaders/target-snowflake/venv/lib/python3.6/site…