The Client Access page has three tabs:
- Export GhostDB
- Test SQL
- View Fileshares
Export GhostDB
This functionality allows you to export data from any GhostDB table your user account has access to, and will include the transformations set per policy for your user account, such as redacting or obfuscating specific fields. Data can be exported in the following formats:
- CSV file
- Parquet file
- Excel xlsx file
To export data, start by clicking on the GhostDB from which you want to export data. Note that only GhostDBs that you have access to will be shown.
Next select the table from which you want to export data.
Select the columns you want to export.
If you want to export all rows, keep the "Pull all results" box checked. If you want only a subset of the rows, uncheck the box and enter the number of rows to export
Note that exporting all data from a table can result in a very big file, and might not be supported by the application or the file system. For example, Excel supports at most 1,048,576 rows, a FAT32 filesystem has a maximum file size of 4 GigaByte. It is also possible that a proxy between you and Dymium will not support large file downloads.
Also note that exporting all data, or lots of data, might have a negative performance impact on the original database server where the data is stored. (note that Dymium does not store your data)
Select the format you want the data to be exported as and click "Export as ..."
Test SQL
The Test SQL tab is used to run an actual SQL query against a GhostDB and table and see the results returned. This helps verifying that the results returned are as expected including configured transformations such as obfuscation.
Note that only the GhostDBs your user account has access to are visible
To run a test, select the Ghost Database and the table and click "Apply"
You can select and deselect columns to show above the results.
Note that the query run is always "select * from <tablename> limit 20;
View Fileshares
Note that View Fileshares is part of Ghost Files and is licensed separately. If your license doesn't include Ghost Files, this tab will not be visible
View Fileshares is a graphical browser to all files that are available for your user account. You can download files here. If PII redaction has been configured, the files download will have the PII contained in them redacted as per policy.
You can see the fileshares your user account has access to. You can browse through your file shares
Clicking on a file will open the file in a preview window from where you can also download the file, including PII redaction as per the configured policy