Export Data from Your SQL Database
Securely export your data to a file for cleaning and validation.
Your Security is Our Priority
Validata does not support direct database connections. This is a deliberate security measure to ensure your database credentials remain private and your live data is never directly exposed. Please follow these guides to export your data to a file securely.
Exporting from PostgreSQL
- Open your terminal or command prompt.
- Connect to your database using `psql`.
- Run the `\copy` command to export data to a CSV file. This command runs on the client side, so the file path is relative to your local machine.
Export an entire table
\copy your_table_name TO '/path/to/your_file.csv' WITH (FORMAT CSV, HEADER);Export specific columns
\copy your_table_name (column1, column2) TO '/path/to/your_file.csv' WITH (FORMAT CSV, HEADER);Export with a condition
\copy (SELECT * FROM your_table_name WHERE status = 'active') TO '/path/to/your_file.csv' WITH (FORMAT CSV, HEADER);Security Best Practices
- Export Only What You Need: Use `WHERE` clauses and specify column names to limit the data you export.
- Anonymize Sensitive Data: Before uploading, consider removing or masking Personally Identifiable Information (PII) if it's not needed for cleaning.
- Use Secure Locations: Save your exported files in a secure, access-controlled directory on your local machine.
- Delete After Use: Once you've successfully uploaded and cleaned your data, delete the local export file.
Next Steps
Once you have your exported CSV or XLSX file, you're ready to get it cleaned!
Go to Upload Page