Storing data from load scripts

Store data using the Store statement. You can store tables as QVD, PARQUET, CSV, or TXT files.

Data load editor and Script include an option, Insert Store statement, to create and format a Store statement.

You can also add and format your own Store statements in your script, which have additional options. For more information, see Store.

Do the following:

1. In Data sources, click on a data source.

2. After Store, enter the name of the table to store.

3. After Path, enter the destination path for the stored file.

   Information note

   For Google Drive targets, folders are specified by ID, not by name or folder path. You must entire the folder ID in the file portion followed by a path separator and the file name. For example:

   STORE [SampleTable] INTO [lib://<connection name>/<folder ID>/test.parquet](parquet);

   You can obtain the folder ID by logging into your Google Drive account.

4. After File, enter the output name and a select the file type.

5. Click Insert.

   The statement is inserted in your script.