Hi, I'm Ask INFA!
What would you like to know?

ASK INFAPreview

Please to access Ask INFA.

404 Resource at '/content/informaticadita-com/en_us/integration-cloud/cloud-mass-ingestion/current-version/_mass-ingestion_cloud-mass-ingestion_current-version_ditamap/mass_ingestion_files_1/configuring_a_file_ingestion_task/configuring_the_target_1/snowflake_data_cloud_target_properties/file_format_and_copy_options/rules_and_guidelines_for_loading_json_files/jcr:content/header/menupage.nocache.html/informaticadita-com/components/content/menu-hover' not found: No resource found

Resource at '/content/informaticadita-com/en_us/integration-cloud/cloud-mass-ingestion/current-version/_mass-ingestion_cloud-mass-ingestion_current-version_ditamap/mass_ingestion_files_1/configuring_a_file_ingestion_task/configuring_the_target_1/snowflake_data_cloud_target_properties/file_format_and_copy_options/rules_and_guidelines_for_loading_json_files/jcr:content/header/menupage.nocache.html/informaticadita-com/components/content/menu-hover' not found: No resource found

Cannot serve request to /content/informaticadita-com/en_us/integration-cloud/cloud-mass-ingestion/current-version/_mass-ingestion_cloud-mass-ingestion_current-version_ditamap/mass_ingestion_files_1/configuring_a_file_ingestion_task/configuring_the_target_1/snowflake_data_cloud_target_properties/file_format_and_copy_options/rules_and_guidelines_for_loading_json_files/_jcr_content/header/menupage.nocache.html/informaticadita-com/components/content/menu-hover on this server

Apache Sling

Search

Mass Ingestion

Mass Ingestion

Back Next

Rules and guidelines for loading JSON files

Rules and guidelines for loading JSON files

Consider the following rule and guideline when you load files of the JSON format to Snowflake Data Cloud.

When you load files of the JSON format to Snowflake Data Cloud, the target table must have only one column of variant type.

To load files of JSON format to columnar format, consider the following tasks:

For example, see the following data view in a table with variant column:

To update the table to columnar format, run the following SQL query from the

Post-processing Commands

field in the mapping task:

INSERT INTO PERSONS_JSON SELECT parse_json($1):email,
parse_json($1):first_name,
parse_json($1):gender,
parse_json($1):id,
parse_json($1):ip_address,
parse_json($1):last_name from PERSONS_JSON_VARIANT

After you run the mapping task, the Secure Agent copies the data in columnar format to Snowflake:

File format and copy options

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.