Strong Security

CSV files are securely stored in the Brewit-hosted Postgres database. Each file will be stored as a table in the database.

​
Import your CSV file

1

Create

Choose CSV or Brewit Workbook here
2

Configure

Edit the table name. Default: the file name
Only letters, numbers, and underscores, must start with a letter, max length 63, all lowercase
3

Check Preview

Click Test Connection button to verify that Brewit can successfully connect to BigQuery. If the test fails, check the data source settings and try again.
4

Save the resource

Click Save button to complete the setup. Now you can start chatting with Brewit’s BI agent to analyze your data.

​
Data Formatting Guidelines

​
❌ Improper data formatting

Composite spreadsheets or irregularly formatted data may not be able to be analyzed or transformed by Brewit. Below are several common issues to avoid:
  • Multiple sections. Your spreadsheet cannot have multiple sections.
  • Multiple tables. Similar to the point above, there should not be multiple tables in your uploaded sheet.
  • Empty rows. Make sure there are no empty rows (or columns).

​
✅ Proper data formatting

Well-cleaned and structured data enables Brewit to perform accurate and error-free data analysis and visualization. Below are best practices to follow:
  • Column headers. Descriptive column headers must be in the first row.
  • Tabulation. Your data should be in the form of rows of records below the headers.
  • Universality. Plain, generally understandable language for column names is recommended rather than industry- or company-specific jargon.