SFTP Server Scheduled Delivery more than 5000 records

vr_2020
Participant II

Hi,

I created a Table chart and saved it as dashboard by using a database Table which comes from Google Big Query. The table in Google Big Query has got more than 5000 records approx. 60,000 rows.

I tried to setup Scheduled SFTP Server delivery in Looker to see if I can get all the 60,000 records in the SFTP server in the form of CSV file. However, I am just getting only 5000 records in the SFTP server.

Looker Documentation says “SFTP server is a good method to use when data or visualization is too large” 

https://docs.looker.com/sharing-and-publishing/scheduling-and-sharing/scheduling-new-dashboards#sftp

53116077-d822-429f-8a08-472c23ff8eae.png

Do anyone tried to Schedule delivery SFTP Server to deliver more than 5000 records to SFTP server? Any help please? 

Any other delivery method that you would suggest apart from Email and SFTP like webhook, Amazon S3, Admin-enabled integrations which would deliver more 5000 records through scheduling?

Solved Solved
0 3 619
1 ACCEPTED SOLUTION

antho
Participant IV

Hello,

You should check this option here: limit ALL Results and you will get all your records in the export 😉

I’m exporting csv with 100.000 rows without issue like this!

6f2e389a-643e-489a-972c-0ca9b5e8bcd6.png

View solution in original post

3 REPLIES 3

antho
Participant IV

Hello,

You should check this option here: limit ALL Results and you will get all your records in the export 😉

I’m exporting csv with 100.000 rows without issue like this!

6f2e389a-643e-489a-972c-0ca9b5e8bcd6.png

vr_2020
Participant II

Hi @antho 

I can see only these options in Looker → Dashboard → Schedule Delivery option when I try through schedule SFTP Server. A different Advanced options settings as shown in the following screenshot

57d4eaeb-f758-4eb3-9dac-f210491d1ea6.png

And as you mentioned “I’m exporting csv with 100.000 rows without issue like this!” . Are you trying to export through Scheduled delivery or manually?

vr_2020
Participant II

Hi @antho - I saved the Table chart from Explore as a Look rather than Dashboard. Now, I can see the Advanced options as per your screenshot in Look → Add Schedule. Thanks

Top Labels in this Space
Top Solution Authors