How can I execute SQL Server stored procedure as Quicksight Custom SQL?
0
I want to show the dashboard with data stored procedure is returning. The stored procedure has one parameter. I am trying to execute EXEC sp_test 8 where 8 is my parameter.
If I put select statement directly, then it is working fine but does not work with stored procedure.
- Stored procedure name:
sp_test
- Parameter name:
@IdentityId
- Parameter value: 8
sql-server amazon-web-services stored-procedures amazon-quicksight edited Jan 1 at 10:38
marc_s
578k12911161262
asked Jan 1 at 10:35
Chirag PatelChirag Patel
33
add a comment |
0
I want to show the dashboard with data stored procedure is returning. The stored procedure has one parameter. I am trying to execute EXEC sp_test 8 where 8 is my parameter.
If I put select statement directly, then it is working fine but does not work with stored procedure.
- Stored procedure name:
sp_test
- Parameter name:
@IdentityId
- Parameter value: 8
sql-server amazon-web-services stored-procedures amazon-quicksight edited Jan 1 at 10:38
marc_s
578k12911161262
asked Jan 1 at 10:35
Chirag PatelChirag Patel
33
Side note: in SQL Server, you should not use thesp_prefix for your stored procedures. Microsoft has reserved that prefix for its own use (see Naming Stored Procedures), and you do run the risk of a name clash sometime in the future. It's also bad for your stored procedure performance. It's best to just simply avoidsp_and use something else as a prefix - or no prefix at all!
– marc_s
Jan 1 at 10:39
add a comment |
0
0
0
I want to show the dashboard with data stored procedure is returning. The stored procedure has one parameter. I am trying to execute EXEC sp_test 8 where 8 is my parameter.
If I put select statement directly, then it is working fine but does not work with stored procedure.
- Stored procedure name:
sp_test
- Parameter name:
@IdentityId
- Parameter value: 8
sql-server amazon-web-services stored-procedures amazon-quicksight edited Jan 1 at 10:38
marc_s
578k12911161262
asked Jan 1 at 10:35
Chirag PatelChirag Patel
33
I want to show the dashboard with data stored procedure is returning. The stored procedure has one parameter. I am trying to execute EXEC sp_test 8 where 8 is my parameter.
If I put select statement directly, then it is working fine but does not work with stored procedure.
- Stored procedure name:
sp_test
- Parameter name:
@IdentityId
- Parameter value: 8
sql-server amazon-web-services stored-procedures amazon-quicksight sql-server amazon-web-services stored-procedures amazon-quicksight edited Jan 1 at 10:38
marc_s
578k12911161262
asked Jan 1 at 10:35
Chirag PatelChirag Patel
33
edited Jan 1 at 10:38
marc_s
578k12911161262
asked Jan 1 at 10:35
Chirag PatelChirag Patel
33
edited Jan 1 at 10:38
marc_s
578k12911161262
edited Jan 1 at 10:38
marc_s
578k12911161262
edited Jan 1 at 10:38
marc_s
578k12911161262
578k12911161262
asked Jan 1 at 10:35
Chirag PatelChirag Patel
33
asked Jan 1 at 10:35
Chirag PatelChirag Patel
33
asked Jan 1 at 10:35
Chirag PatelChirag Patel
33
33
Side note: in SQL Server, you should not use thesp_prefix for your stored procedures. Microsoft has reserved that prefix for its own use (see Naming Stored Procedures), and you do run the risk of a name clash sometime in the future. It's also bad for your stored procedure performance. It's best to just simply avoidsp_and use something else as a prefix - or no prefix at all!
– marc_s
Jan 1 at 10:39
add a comment |
Side note: in SQL Server, you should not use thesp_prefix for your stored procedures. Microsoft has reserved that prefix for its own use (see Naming Stored Procedures), and you do run the risk of a name clash sometime in the future. It's also bad for your stored procedure performance. It's best to just simply avoidsp_and use something else as a prefix - or no prefix at all!
– marc_s
Jan 1 at 10:39
Side note: in SQL Server, you should not use the
sp_ prefix for your stored procedures. Microsoft has reserved that prefix for its own use (see Naming Stored Procedures), and you do run the risk of a name clash sometime in the future. It's also bad for your stored procedure performance. It's best to just simply avoid sp_ and use something else as a prefix - or no prefix at all!– marc_s
Jan 1 at 10:39
Side note: in SQL Server, you should not use the
sp_ prefix for your stored procedures. Microsoft has reserved that prefix for its own use (see Naming Stored Procedures), and you do run the risk of a name clash sometime in the future. It's also bad for your stored procedure performance. It's best to just simply avoid sp_ and use something else as a prefix - or no prefix at all!– marc_s
Jan 1 at 10:39
add a comment |
0
active
oldest
votes
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');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53994772%2fhow-can-i-execute-sql-server-stored-procedure-as-quicksight-custom-sql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53994772%2fhow-can-i-execute-sql-server-stored-procedure-as-quicksight-custom-sql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Side note: in SQL Server, you should not use the
sp_prefix for your stored procedures. Microsoft has reserved that prefix for its own use (see Naming Stored Procedures), and you do run the risk of a name clash sometime in the future. It's also bad for your stored procedure performance. It's best to just simply avoidsp_and use something else as a prefix - or no prefix at all!– marc_s
Jan 1 at 10:39