search

Snowflake-Labs / Excelerator

This is an Excel Addin for Windows that reads and writes data to Snowflake
Apache License 2.0
78 stars 22 forks source link

No access to CREATE STAGES #6

Closed terry-campbell-od closed 3 years ago

terry-campbell-od commented 3 years ago

Can Excelerator be modified to optionally use the user stage (@~) instead of creating a stage to upload data?

ssegal100 commented 3 years ago

Hi @terry-campbell-od. Unfortunately it can't because both user and table stages have some limitations. In the upload process the skip_header is changed depending on weather or not there are data types in the first row. I've tried it a couple of times only to hit a wall. User stages can't be altered. Happy to discuss possibilities though. Also, if a stage is not provided, a temporary one will be created and then dropped. So the user needs to have that appropriate role.

terry-campbell-od commented 3 years ago

Thanks for getting back so quickly and for the explanation. I would like to discuss. Let me do some debugging to see exactly where I am failing. I will reply back.

ssegal100 commented 3 years ago

You're welcome. I believe that the issue arose in the stored procedures, and they are only used when auto-detecting data types. I'm feeling like the auto-detect data types feature is causing more complexity than it's worth. So, I think that if we find that the request is not using it, we might be able to use the User Stage. Please have a look, that would be great.

ssegal100 commented 3 years ago

@terry-campbell-od I've dug into this one and looks like I still can't use the user stage. I'm going to close the issue but let me know if you want to discuss more. Steve