Hi, thanks for the interesting video. Out of curiosity, have you ever tried importing ONS geoJSON data into snowflake? I was using your video as a guide but I'm getting a ton of errors.
@@mastering_snowflake that would be awesome! it's available here: geoportal.statistics.gov.uk/datasets/ons::lower-layer-super-output-areas-december-2021-boundaries-full-clipped-ew-bfc/explore?location=52.763209%2C-2.489483%2C7.20
Ok I got it to work in the end. Your main problem is the file size I believe. It was 1.6GB downloaded for me. When I tried to copy it into Snowflake I got a maximum file size exceed error. When I pulled a single JSON record out as a test I was able to load it directly into a geography column in the table without issue. No doubt people out there may have neat workarounds, as such I'll let others chime in.
Why SSRS Map visual is not recognising snowflake spatial data?
Hi, thanks for the interesting video. Out of curiosity, have you ever tried importing ONS geoJSON data into snowflake? I was using your video as a guide but I'm getting a ton of errors.
I haven’t but happy to take a look if you’re able to share the data set
@@mastering_snowflake that would be awesome! it's available here:
geoportal.statistics.gov.uk/datasets/ons::lower-layer-super-output-areas-december-2021-boundaries-full-clipped-ew-bfc/explore?location=52.763209%2C-2.489483%2C7.20
Ok I got it to work in the end. Your main problem is the file size I believe. It was 1.6GB downloaded for me. When I tried to copy it into Snowflake I got a maximum file size exceed error.
When I pulled a single JSON record out as a test I was able to load it directly into a geography column in the table without issue.
No doubt people out there may have neat workarounds, as such I'll let others chime in.
@@mastering_snowflake did you use the same import process as above? I'll try inserting it in chunks