JSON(variant) & BINARY data type support

[sfc-gh-wriley]

I notice that when ingesting data, VARIANT & BINARY data types are not ingested... is there any workaround or anything you could suggest for being able to do this?

[ssegal100]

I'm a little surprised that doesn't work. Would you upload a sample copy of the spreadsheet with dummy data. I don't recall testing that, but I'm not sure what it doesn't work.

[sfc-gh-wriley]

Sure - I've not tested upload, but was downloading data from two tables (one with binary, the other with Variant/json).

No data was returned to Excel for both columns

Regards,

Will Will RILEY Solutions Architect

On Wed, 24 Nov 2021 at 14:06, Steven Segal @.***> wrote:

I'm a little surprised that doesn't work. Would you upload a sample copy of the spreadsheet with dummy data. I don't recall testing that, but I'm not sure what it doesn't work.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/Snowflake-Labs/Excelerator/issues/29#issuecomment-977910239, or unsubscribe https://github.com/notifications/unsubscribe-auth/ASLPQ4B4JDNHXPDZLKB2HRTUNTWOVANCNFSM5IWDPWSQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

[ssegal100]

Oh I see. I'll take a look.

On Wed, Nov 24, 2021 at 8:09 AM Will Riley @.***> wrote:

Sure - I've not tested upload, but was downloading data from two tables (one with binary, the other with Variant/json).

No data was returned to Excel for both columns

Regards,

Will Will RILEY Solutions Architect

MOBILE +447966939179 EMAIL @.***

Snowflake Inc. 207 Old Street London, EC1V 9NR, United Kingdom

On Wed, 24 Nov 2021 at 14:06, Steven Segal @.***> wrote:

I'm a little surprised that doesn't work. Would you upload a sample copy of the spreadsheet with dummy data. I don't recall testing that, but I'm not sure what it doesn't work.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub < https://github.com/Snowflake-Labs/Excelerator/issues/29#issuecomment-977910239 , or unsubscribe < https://github.com/notifications/unsubscribe-auth/ASLPQ4B4JDNHXPDZLKB2HRTUNTWOVANCNFSM5IWDPWSQ

. Triage notifications on the go with GitHub Mobile for iOS < https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675

or Android < https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub .

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/Snowflake-Labs/Excelerator/issues/29#issuecomment-977912735, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADFJJTWITBYG54P2IPYKGMTUNTWZXANCNFSM5IWDPWSQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

[sfc-gh-wriley]

I've pinged you the details internally on Slack ;-)

[kangprog]

Please share the progress of this issue. Array types and object types are also not supported.