Export to CSV in NoSQL workbench exports only those that is shown in the grid

0

Hi, I started using NoSQL workbench today. I am able to connect and view the Dynamo DB table in my AWS account.

I set the 'Item count per page' to 100 .... but that also applies to Export to CSV. I am able to export only 100 at a time.

How can I export ALL, records that satisfy the GSI being used.

thanks Jeevan

질문됨 일 년 전522회 조회
1개 답변
0

Hi Jeevan,

There are a few ways of doing this with NoSQL Workbench. Have a read of the NoSQL Documentation for Building Complex Operations which will take you through different ways of handling data.

A couple of approaches to look at:

  1. Build a Scan operation using the Operation Builder. Select the Connection, Region and Table to query, make sure "Interface-based operations" is selected, then click on "Expand Operation" near the top of the screen. Here you can choose "Scan" against your table which will retrieve all the data from your table, which you can then Export to CSV.

  2. Build a PartiQL operation using the Operation Builder. Again select the Connection, Region and Table to query but this time select "PartiQL operations" at the top of the screen. Now you can write PartiQL statements to extract data as you need from your table, and again Export to CSV is available once you've extracted the data.

Please note that extracting all data from DynamoDB can carry out a Scan on your entire DynamoDB and if you're working with large amounts of data, please be aware of the DynamoDB Pricing information before you run your extracts.

AWS
답변함 일 년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠