Creating Physical Datasets
A physical dataset is built directly from an existing database table. It doesn't require writing SQL queries or transforming the data. This type of dataset is best for simple use cases where the table's existing structure works well for reporting and analysis.
Creating Virtual Datasets with only the required columns (projections) is a recommended approach. It helps optimize performance, reduce data load, and improve the clarity and relevance of your visualizations by including only the data needed for analysis.
