Transactions.value:"values"."customer.custate"::string as customer_end_date, Transactions.value:"values"."customer.altname"::string as customer_project_name, Transactions.value:"values".currency.value::string as currency_val, Transactions.value:"values".currency.text::string as currency_text, Transactions.value:"values".classnohierarchy.value::string as class_val,** **transactions.value:"values".classnohierarchy.text::string as class_txt, Transactions.value:"values".amount::string as amount, Transactions.value:"values"."account.type".value::string as acc_type_val, Transactions.value:"values"."account.type".text::string as acc_type_txt, Transactions.value:"values"."account.number"::string as acc_num, Transactions.value:"values".account.value as val, Transactions.value:"values".account.text as text, Transactions.value:"values".account as acc, Transactions.value:"values"::variant as trans_val, Transactions.value:recordType::string as record_type, JSON_DATA:status::string as connection_status, Transactions.value:"values".classnohierarchy.value::string as class_val, I've been able to query the values that are not (deeply) nested but I need help getting, for example, the values from 'classnohierarchy', to get both the 'text' and 'value' I tried: transactions.value:"values".classnohierarchy.text::string as class_txt, "customer.altname": "V Sties expenses (Tor)", So, I've created a JSON_DATA variant column and plan to query and do a COPY INTO another table, but my query isn't working yet. I need some help querying this JSON file I've ingested into a temp table in Snowflake.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |