Hi, I'm using loader snowflake, with tap oracle as...
# troubleshooting
d
Hi, I'm using loader snowflake, with tap oracle as origin. Already tested oracle and snowflake connections are OK, and trying to load a single table just to check it works fine. The table is created on Snowflake just fine, but the ELT gets stucked in this query and seems to never end:
Copy code
SELECT "schema_name" AS schema_name
,"table_name" AS table_name
,"column_name" AS column_name
,CASE PARSE_JSON("data_type"):type::varchar
WHEN 'FIXED' THEN 'NUMBER'
WHEN 'REAL' THEN 'FLOAT'r
ELSE PARSE_JSON("data_type"):type::varchar
END data_type
FROM TABLE(RESULT_SCAN(%(LAST_QID)s))
with Params {'LAST_QID': '01a2b32e-0301-160f-0000-462d2473eed6'}
Any ideas? Thank you