How to export Google spanner query results to .csv or google sheets?
I am new to google spanner and I have run a query and found about 50k rows of data. I want to export that resultset to my local machine like .csv or into a google sheet. Previously I have used TOAD where I have an export button, but here I do not see any of those options. Any suggestions please.
google-cloud-platform export resultset google-cloud-spanner
edited Dec 21 '18 at 13:27
Maxim
1,498210
asked Nov 23 '18 at 18:09
MuraliMurali
61
add a comment |
I am new to google spanner and I have run a query and found about 50k rows of data. I want to export that resultset to my local machine like .csv or into a google sheet. Previously I have used TOAD where I have an export button, but here I do not see any of those options. Any suggestions please.
google-cloud-platform export resultset google-cloud-spanner
edited Dec 21 '18 at 13:27
Maxim
1,498210
asked Nov 23 '18 at 18:09
MuraliMurali
61
add a comment |
I am new to google spanner and I have run a query and found about 50k rows of data. I want to export that resultset to my local machine like .csv or into a google sheet. Previously I have used TOAD where I have an export button, but here I do not see any of those options. Any suggestions please.
google-cloud-platform export resultset google-cloud-spanner
edited Dec 21 '18 at 13:27
Maxim
1,498210
asked Nov 23 '18 at 18:09
MuraliMurali
61
I am new to google spanner and I have run a query and found about 50k rows of data. I want to export that resultset to my local machine like .csv or into a google sheet. Previously I have used TOAD where I have an export button, but here I do not see any of those options. Any suggestions please.
google-cloud-platform export resultset google-cloud-spanner
google-cloud-platform export resultset google-cloud-spanner
edited Dec 21 '18 at 13:27
Maxim
1,498210
asked Nov 23 '18 at 18:09
MuraliMurali
61
edited Dec 21 '18 at 13:27
Maxim
1,498210
asked Nov 23 '18 at 18:09
MuraliMurali
61
edited Dec 21 '18 at 13:27
Maxim
1,498210
edited Dec 21 '18 at 13:27
Maxim
1,498210
edited Dec 21 '18 at 13:27
Maxim
1,498210
1,498210
asked Nov 23 '18 at 18:09
MuraliMurali
61
asked Nov 23 '18 at 18:09
MuraliMurali
61
asked Nov 23 '18 at 18:09
MuraliMurali
61
61
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
The gcloud spanner databases execute-sql command allows you to run SQL statements on the command line and redirect output to a file.
The --format=csv global argument should output in CSV.
https://cloud.google.com/spanner/docs/gcloud-spanner
https://cloud.google.com/sdk/gcloud/reference/
answered Nov 23 '18 at 19:08
RedPandaCuriosRedPandaCurios
1,536817
add a comment |
You could use a number of standard database tools with Google Cloud Spanner using a JDBC driver.
Have a look at this article: https://www.googlecloudspanner.com/2017/10/using-standard-database-tools-with.html
Toad is not included as an example, and I don't know if Toad supports dynamic loading of JDBC drivers and connecting to any generic JDBC database. If not, you could try one of the other tools listed in the article. Most of them would also include an export function.
answered Nov 23 '18 at 18:35
Knut Olav LoiteKnut Olav Loite
432211
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
});
}
});
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%2f53451273%2fhow-to-export-google-spanner-query-results-to-csv-or-google-sheets%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
The gcloud spanner databases execute-sql command allows you to run SQL statements on the command line and redirect output to a file.
The --format=csv global argument should output in CSV.
https://cloud.google.com/spanner/docs/gcloud-spanner
https://cloud.google.com/sdk/gcloud/reference/
answered Nov 23 '18 at 19:08
RedPandaCuriosRedPandaCurios
1,536817
add a comment |
The gcloud spanner databases execute-sql command allows you to run SQL statements on the command line and redirect output to a file.
The --format=csv global argument should output in CSV.
https://cloud.google.com/spanner/docs/gcloud-spanner
https://cloud.google.com/sdk/gcloud/reference/
answered Nov 23 '18 at 19:08
RedPandaCuriosRedPandaCurios
1,536817
add a comment |
The gcloud spanner databases execute-sql command allows you to run SQL statements on the command line and redirect output to a file.
The --format=csv global argument should output in CSV.
https://cloud.google.com/spanner/docs/gcloud-spanner
https://cloud.google.com/sdk/gcloud/reference/
answered Nov 23 '18 at 19:08
RedPandaCuriosRedPandaCurios
1,536817
The gcloud spanner databases execute-sql command allows you to run SQL statements on the command line and redirect output to a file.
The --format=csv global argument should output in CSV.
https://cloud.google.com/spanner/docs/gcloud-spanner
https://cloud.google.com/sdk/gcloud/reference/
answered Nov 23 '18 at 19:08
RedPandaCuriosRedPandaCurios
1,536817
edited Dec 7 '18 at 15:43
answered Nov 23 '18 at 19:08
RedPandaCuriosRedPandaCurios
1,536817
answered Nov 23 '18 at 19:08
RedPandaCuriosRedPandaCurios
1,536817
answered Nov 23 '18 at 19:08
RedPandaCuriosRedPandaCurios
1,536817
1,536817
add a comment |
add a comment |
You could use a number of standard database tools with Google Cloud Spanner using a JDBC driver.
Have a look at this article: https://www.googlecloudspanner.com/2017/10/using-standard-database-tools-with.html
Toad is not included as an example, and I don't know if Toad supports dynamic loading of JDBC drivers and connecting to any generic JDBC database. If not, you could try one of the other tools listed in the article. Most of them would also include an export function.
answered Nov 23 '18 at 18:35
Knut Olav LoiteKnut Olav Loite
432211
add a comment |
You could use a number of standard database tools with Google Cloud Spanner using a JDBC driver.
Have a look at this article: https://www.googlecloudspanner.com/2017/10/using-standard-database-tools-with.html
Toad is not included as an example, and I don't know if Toad supports dynamic loading of JDBC drivers and connecting to any generic JDBC database. If not, you could try one of the other tools listed in the article. Most of them would also include an export function.
answered Nov 23 '18 at 18:35
Knut Olav LoiteKnut Olav Loite
432211
add a comment |
You could use a number of standard database tools with Google Cloud Spanner using a JDBC driver.
Have a look at this article: https://www.googlecloudspanner.com/2017/10/using-standard-database-tools-with.html
Toad is not included as an example, and I don't know if Toad supports dynamic loading of JDBC drivers and connecting to any generic JDBC database. If not, you could try one of the other tools listed in the article. Most of them would also include an export function.
answered Nov 23 '18 at 18:35
Knut Olav LoiteKnut Olav Loite
432211
You could use a number of standard database tools with Google Cloud Spanner using a JDBC driver.
Have a look at this article: https://www.googlecloudspanner.com/2017/10/using-standard-database-tools-with.html
Toad is not included as an example, and I don't know if Toad supports dynamic loading of JDBC drivers and connecting to any generic JDBC database. If not, you could try one of the other tools listed in the article. Most of them would also include an export function.
answered Nov 23 '18 at 18:35
Knut Olav LoiteKnut Olav Loite
432211
answered Nov 23 '18 at 18:35
Knut Olav LoiteKnut Olav Loite
432211
answered Nov 23 '18 at 18:35
Knut Olav LoiteKnut Olav Loite
432211
answered Nov 23 '18 at 18:35
Knut Olav LoiteKnut Olav Loite
432211
432211
add a comment |
add a comment |
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.
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%2f53451273%2fhow-to-export-google-spanner-query-results-to-csv-or-google-sheets%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
