Unable to run a stored procedure in snowflake database

CREATE OR REPLACE PROCEDURE wh.sp_schema.my_sp(arg1 STRING, arg2 STRING)

RETURNS VARCHAR(16777216)

LANGUAGE JAVASCRIPT

AS 

$$

 stmt = snowflake.createStatement(

  {sqlText: `CREATE OR REPLACE TABLE wh.table_schema.RAW_`+arg2+`_`+arg1+` LIKE wh.temp_schema.RAW_`+arg2+`_TEMPLATE`}

  );

rs = stmt.execute();

rs.next();

output = rs.getColumnValue(1);

return output;

$$

;

when i create the above stored procedure - below message is displayed

Function my_sp successfully created.

when i run the stored procedure from the worksheet using

CALL my_sp('2018','abc');

I see the below error:

SQL compilation error: Invalid identifier my_sp

I even tried running using fully qualified name for the stored procedure:

CALL wh.sp_schema.my_sp('2018','abc');

I still see the below error:

SQL compilation error: Invalid identifier my_sp.

Also, i would like to know a command to see if my stored procedure has been created or not.
I've looked in the snowflake UI, under 'wh" warehouse and "sp_schema" schema, but could not see anything(stored procedures) other than tables.

edited Jan 10 at 7:19

a1626

2,81211231

asked Nov 27 '18 at 14:12

srini

add a comment |

CREATE OR REPLACE PROCEDURE wh.sp_schema.my_sp(arg1 STRING, arg2 STRING)

RETURNS VARCHAR(16777216)

LANGUAGE JAVASCRIPT

AS 

$$

 stmt = snowflake.createStatement(

  {sqlText: `CREATE OR REPLACE TABLE wh.table_schema.RAW_`+arg2+`_`+arg1+` LIKE wh.temp_schema.RAW_`+arg2+`_TEMPLATE`}

  );

rs = stmt.execute();

rs.next();

output = rs.getColumnValue(1);

return output;

$$

;

when i create the above stored procedure - below message is displayed

Function my_sp successfully created.

when i run the stored procedure from the worksheet using

CALL my_sp('2018','abc');

I see the below error:

SQL compilation error: Invalid identifier my_sp

I even tried running using fully qualified name for the stored procedure:

CALL wh.sp_schema.my_sp('2018','abc');

I still see the below error:

SQL compilation error: Invalid identifier my_sp.

edited Jan 10 at 7:19

a1626

2,81211231

asked Nov 27 '18 at 14:12

srini

add a comment |

CREATE OR REPLACE PROCEDURE wh.sp_schema.my_sp(arg1 STRING, arg2 STRING)

RETURNS VARCHAR(16777216)

LANGUAGE JAVASCRIPT

AS 

$$

 stmt = snowflake.createStatement(

  {sqlText: `CREATE OR REPLACE TABLE wh.table_schema.RAW_`+arg2+`_`+arg1+` LIKE wh.temp_schema.RAW_`+arg2+`_TEMPLATE`}

  );

rs = stmt.execute();

rs.next();

output = rs.getColumnValue(1);

return output;

$$

;

when i create the above stored procedure - below message is displayed

Function my_sp successfully created.

when i run the stored procedure from the worksheet using

CALL my_sp('2018','abc');

I see the below error:

SQL compilation error: Invalid identifier my_sp

I even tried running using fully qualified name for the stored procedure:

CALL wh.sp_schema.my_sp('2018','abc');

I still see the below error:

SQL compilation error: Invalid identifier my_sp.

edited Jan 10 at 7:19

a1626

2,81211231

asked Nov 27 '18 at 14:12

srini

CREATE OR REPLACE PROCEDURE wh.sp_schema.my_sp(arg1 STRING, arg2 STRING)

RETURNS VARCHAR(16777216)

LANGUAGE JAVASCRIPT

AS 

$$

 stmt = snowflake.createStatement(

  {sqlText: `CREATE OR REPLACE TABLE wh.table_schema.RAW_`+arg2+`_`+arg1+` LIKE wh.temp_schema.RAW_`+arg2+`_TEMPLATE`}

  );

rs = stmt.execute();

rs.next();

output = rs.getColumnValue(1);

return output;

$$

;

when i create the above stored procedure - below message is displayed

Function my_sp successfully created.

when i run the stored procedure from the worksheet using

CALL my_sp('2018','abc');

I see the below error:

SQL compilation error: Invalid identifier my_sp

I even tried running using fully qualified name for the stored procedure:

CALL wh.sp_schema.my_sp('2018','abc');

I still see the below error:

SQL compilation error: Invalid identifier my_sp.

stored-procedures snowflake-datawarehouse snowflake

edited Jan 10 at 7:19

a1626

2,81211231

asked Nov 27 '18 at 14:12

srini

edited Jan 10 at 7:19

a1626

2,81211231

asked Nov 27 '18 at 14:12

srini

edited Jan 10 at 7:19

a1626

2,81211231

edited Jan 10 at 7:19

a1626

2,81211231

edited Jan 10 at 7:19

a1626

2,81211231

asked Nov 27 '18 at 14:12

srini

asked Nov 27 '18 at 14:12

srini

asked Nov 27 '18 at 14:12

srini

add a comment |

1 Answer
1

active

oldest

votes

Snowflake does not support Stored Procedures. They are implementingjavascript` based APIs for it, but it's still in draft mode.

Here's the link to their APIs (Note Draft Document is written on right hand side).

and here's the link to a ticket on their support forum where they've confirmed it.

answered Jan 10 at 7:19

a1626

2,81211231

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53501619%2funable-to-run-a-stored-procedure-in-snowflake-database%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

Snowflake does not support Stored Procedures. They are implementingjavascript` based APIs for it, but it's still in draft mode.

Here's the link to their APIs (Note Draft Document is written on right hand side).

and here's the link to a ticket on their support forum where they've confirmed it.

answered Jan 10 at 7:19

a1626

2,81211231

add a comment |

Snowflake does not support Stored Procedures. They are implementingjavascript` based APIs for it, but it's still in draft mode.

Here's the link to their APIs (Note Draft Document is written on right hand side).

and here's the link to a ticket on their support forum where they've confirmed it.

answered Jan 10 at 7:19

a1626

2,81211231

add a comment |

Snowflake does not support Stored Procedures. They are implementingjavascript` based APIs for it, but it's still in draft mode.

Here's the link to their APIs (Note Draft Document is written on right hand side).

and here's the link to a ticket on their support forum where they've confirmed it.

answered Jan 10 at 7:19

a1626

2,81211231

Snowflake does not support Stored Procedures. They are implementingjavascript` based APIs for it, but it's still in draft mode.

Here's the link to their APIs (Note Draft Document is written on right hand side).

and here's the link to a ticket on their support forum where they've confirmed it.

answered Jan 10 at 7:19

a1626

2,81211231

answered Jan 10 at 7:19

a1626

2,81211231

answered Jan 10 at 7:19

a1626

2,81211231

answered Jan 10 at 7:19

a1626

2,81211231

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Btukfyl