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

Cal SP #17

Closed GouriprasadMP closed 3 years ago

GouriprasadMP commented 3 years ago

Hi, Can you please guide me by letting me know if there is a way by which I can excute Call stored procedure from the Plug in Regards, G

ssegal100 commented 3 years ago

Yes you can just use the Query feature, but instead of creating a SQL statement use the 'Call' syntax. For example if you have a stored procedure named exceltest, you can call it this way. call exceltest(); You will either need to use a fully qualified call like this: call mydatabase.public.exceltest() or you can select the database and schema and then set the default database by clicking 'Make Default' check box to the right of the Schema in the Query dialog. image

Does this help? Steve

GouriprasadMP commented 3 years ago

Hi, Thanks a ton for your quick response. I tried before reaching you the SQL option I see only Tables and views from DB but not this AutoCreate option is it the version issue? Thank you

ssegal100 commented 3 years ago

Oh, I think I misunderstood your question. The Autocreate functionality has been removed because of some complications. Is it something that you would like? If there is demand for it then I'll work on it, but it hasn't been used much so I don't think it was worth it. Let me know what you think. Steve

GouriprasadMP commented 3 years ago

Yes,I want to leavarage the Plugin and excute the SP. If you can help by giving that plugin that will be of great help Many Thanks, G

GouriprasadMP commented 3 years ago

Hi Steve, Greetings! Will you be able to help with Add-in with which I can call SP from Excel please Regards, G

ssegal100 commented 3 years ago

Sorry for the delay. This feature adds another level of complexity. I will have to update it based on recent changes and test it thoroughly if it substantially adds value. Before doing this, I really want to make sure there will be sufficient value. Would you help me understand the value to your team? The reason I think there could be limited value is because the column datatypes can be manually defined and I don't know how many new tables or columns users will add that need this. Let me know what you think. Thanks.

GouriprasadMP commented 3 years ago

Thank you so much. Here is why I am asking our users will load the data based on need and based on their comfort and time from excel using the plugin to snowflake.Once they load the data...I have an SP which they have to run to see the output in power BI. Hope this helps

On Thu, Feb 25, 2021 at 9:00 PM Steven Segal notifications@github.com wrote:

Sorry for the delay. This feature adds another level of complexity. I will have to update it based on recent changes and test it thoroughly if it substantially adds value. Before doing this, I really want to make sure there will be sufficient value. Would you help me understand the value to your team? The reason I think there could be limited value is because the column datatypes can be manually defined and I don't know how many new tables or columns users will add that need this. Let me know what you think. Thanks.

— 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/17#issuecomment-785987277, or unsubscribe https://github.com/notifications/unsubscribe-auth/AS3SAIQ2GIA3S5SU27MVR63TAZUJDANCNFSM4XVFKS4A .

-- https://bottr.me/gouriprasad?utm_source=emailSignature

Gouri Prasad

@gouriprasad https://bottr.me/gouriprasad?utm_source=emailSignature

ssegal100 commented 3 years ago

I'm not clear on the request. Is it to run any SP or is it specifically for the autodetect datatype feature?

GouriprasadMP commented 3 years ago

To run SP

On Fri, 26 Feb 2021, 12:14 am Steven Segal, notifications@github.com wrote:

I'm not clear on the request. Is it to run any SP or is it specifically for the autodetect datatype feature?

— 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/17#issuecomment-786119605, or unsubscribe https://github.com/notifications/unsubscribe-auth/AS3SAIVAZCTVQLBBMJIXDLDTA2LALANCNFSM4XVFKS4A .

GouriprasadMP commented 3 years ago

Hi Steve, Kindly let me know if have any other questions Thanks, G

On Fri, 26 Feb 2021, 5:47 pm Gouri Prasad, gouriprasadmp@gmail.com wrote:

To run SP

On Fri, 26 Feb 2021, 12:14 am Steven Segal, notifications@github.com wrote:

I'm not clear on the request. Is it to run any SP or is it specifically for the autodetect datatype feature?

— 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/17#issuecomment-786119605, or unsubscribe https://github.com/notifications/unsubscribe-auth/AS3SAIVAZCTVQLBBMJIXDLDTA2LALANCNFSM4XVFKS4A .

ssegal100 commented 3 years ago

I'm having a hard time understanding what you are asking for. Can we get on a call together next week?

GouriprasadMP commented 3 years ago

Hi Steve, Sure,but what I am asking is to help with an option to execute call procedure from excel. Pl ping me on WhatsApp would love to talk to you My number +917799099663 Weekend this Saturday or Sunday would be best for call Thanks a ton

On Sat, 27 Feb 2021, 4:23 am Steven Segal, notifications@github.com wrote:

I'm having a hard time understanding what you are asking for. Can we get on a call together next week?

— 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/17#issuecomment-786937676, or unsubscribe https://github.com/notifications/unsubscribe-auth/AS3SAISZZZ5OA7Y76SGLA6DTBAQ7BANCNFSM4XVFKS4A .

GouriprasadMP commented 3 years ago

Hi Steve, Just to clarify what help I am looking at is excalty the same what you have shown in the first post.Attaaching the same here again. We can talk over whatsapp Today,tomorrow based on your availibilty -My number -+917799099663.Thanks again CALLSP

ssegal100 commented 3 years ago

Hi Gouri. Is there any more assistance needed here? If not we can can close this issue. Thanks!

GouriprasadMP commented 3 years ago

Pl close dear Steve

On Tue, 23 Mar 2021, 9:00 pm Steven Segal, @.***> wrote:

Hi Gouri. Is there any more assistance needed here? If not we can can close this issue. Thanks!

— 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/17#issuecomment-804999602, or unsubscribe https://github.com/notifications/unsubscribe-auth/AS3SAIQP5CT3O34F6547UELTFCXZ5ANCNFSM4XVFKS4A .