Windsor brings all your Metabase data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Metabase Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| cards__archived | BOOLEAN | cards.archived | cards.archived | cards |
| cards__cache_ttl | NUMERIC | cards.cache_ttl | cards.cache_ttl | cards |
| cards__collection | OBJECT | cards.collection | cards.collection | cards |
| cards__collection_id | NUMERIC | cards.collection_id | cards.collection_id | cards |
| cards__collection_position | NUMERIC | cards.collection_position | cards.collection_position | cards |
| cards__created_at | TEXT | cards.created_at | cards.created_at | cards |
| cards__creator | OBJECT | cards.creator | cards.creator | cards |
| cards__creator_id | NUMERIC | cards.creator_id | cards.creator_id | cards |
| cards__database_id | NUMERIC | cards.database_id | cards.database_id | cards |
| cards__dataset | BOOLEAN | cards.dataset | cards.dataset | cards |
| cards__dataset_query | OBJECT | cards.dataset_query | cards.dataset_query | cards |
| cards__description | TEXT | cards.description | cards.description | cards |
| cards__display | TEXT | cards.display | cards.display | cards |
| cards__embedding_params | TEXT | cards.embedding_params | cards.embedding_params | cards |
| cards__enable_embedding | BOOLEAN | cards.enable_embedding | cards.enable_embedding | cards |
| cards__id | NUMERIC | cards.id | cards.id | cards |
| cards__last-edit-info | OBJECT | cards.last-edit-info | cards.last-edit-info | cards |
| cards__made_public_by_id | NUMERIC | cards.made_public_by_id | cards.made_public_by_id | cards |
| cards__name | TEXT | cards.name | cards.name | cards |
| cards__public_uuid | TEXT | cards.public_uuid | cards.public_uuid | cards |
| cards__query_type | TEXT | cards.query_type | cards.query_type | cards |
| cards__result_metadata | OBJECT | cards.result_metadata | cards.result_metadata | cards |
| cards__table_id | NUMERIC | cards.table_id | cards.table_id | cards |
| cards__updated_at | TEXT | cards.updated_at | cards.updated_at | cards |
| cards__visualization_settings | OBJECT | cards.visualization_settings | cards.visualization_settings | cards |
| collections__archived | BOOLEAN | collections.archived | collections.archived | collections |
| collections__authority_level | TEXT | collections.authority_level | collections.authority_level | collections |
| collections__can_write | BOOLEAN | collections.can_write | collections.can_write | collections |
| collections__color | TEXT | collections.color | collections.color | collections |
| collections__description | TEXT | collections.description | collections.description | collections |
| collections__id | NUMERIC | collections.id | collections.id | collections |
| collections__location | TEXT | collections.location | collections.location | collections |
| collections__name | TEXT | collections.name | collections.name | collections |
| collections__namespace | TEXT | collections.namespace | collections.namespace | collections |
| collections__personal_owner_id | NUMERIC | collections.personal_owner_id | collections.personal_owner_id | collections |
| collections__slug | TEXT | collections.slug | collections.slug | collections |
| dashboards__archived | BOOLEAN | dashboards.archived | dashboards.archived | dashboards |
| dashboards__cache_ttl | NUMERIC | dashboards.cache_ttl | dashboards.cache_ttl | dashboards |
| dashboards__caveats | TEXT | dashboards.caveats | dashboards.caveats | dashboards |
| dashboards__collection_id | NUMERIC | dashboards.collection_id | dashboards.collection_id | dashboards |
| dashboards__collection_position | NUMERIC | dashboards.collection_position | dashboards.collection_position | dashboards |
| dashboards__created_at | TEXT | dashboards.created_at | dashboards.created_at | dashboards |
| dashboards__creator | OBJECT | dashboards.creator | dashboards.creator | dashboards |
| dashboards__creator_id | NUMERIC | dashboards.creator_id | dashboards.creator_id | dashboards |
| dashboards__description | TEXT | dashboards.description | dashboards.description | dashboards |
| dashboards__embedding_params | OBJECT | dashboards.embedding_params | dashboards.embedding_params | dashboards |
| dashboards__enable_embedding | BOOLEAN | dashboards.enable_embedding | dashboards.enable_embedding | dashboards |
| dashboards__id | NUMERIC | dashboards.id | dashboards.id | dashboards |
| dashboards__last-edit-info | OBJECT | dashboards.last-edit-info | dashboards.last-edit-info | dashboards |
| dashboards__made_public_by_id | NUMERIC | dashboards.made_public_by_id | dashboards.made_public_by_id | dashboards |
| dashboards__name | TEXT | dashboards.name | dashboards.name | dashboards |
| dashboards__parameters | OBJECT | dashboards.parameters | dashboards.parameters | dashboards |
| dashboards__points_of_interest | TEXT | dashboards.points_of_interest | dashboards.points_of_interest | dashboards |
| dashboards__position | TEXT | dashboards.position | dashboards.position | dashboards |
| dashboards__public_uuid | TEXT | dashboards.public_uuid | dashboards.public_uuid | dashboards |
| dashboards__show_in_getting_started | BOOLEAN | dashboards.show_in_getting_started | dashboards.show_in_getting_started | dashboards |
| dashboards__updated_at | TEXT | dashboards.updated_at | dashboards.updated_at | dashboards |
| databases__auto_run_queries | BOOLEAN | databases.auto_run_queries | databases.auto_run_queries | databases |
| databases__cache_field_values_schedule | TEXT | databases.cache_field_values_schedule | databases.cache_field_values_schedule | databases |
| databases__cache_ttl | NUMERIC | databases.cache_ttl | databases.cache_ttl | databases |
| databases__can_upload | BOOLEAN | databases.can_upload | databases.can_upload | databases |
| databases__caveats | TEXT | databases.caveats | databases.caveats | databases |
| databases__created_at | TEXT | databases.created_at | databases.created_at | databases |
| databases__creator_id | NUMERIC | databases.creator_id | databases.creator_id | databases |
| databases__dbms_version | OBJECT | databases.dbms_version | databases.dbms_version | databases |
| databases__description | TEXT | databases.description | databases.description | databases |
| databases__details | OBJECT | databases.details | databases.details | databases |
| databases__engine | TEXT | databases.engine | databases.engine | databases |
| databases__features | OBJECT | databases.features | databases.features | databases |
| databases__id | NUMERIC | databases.id | databases.id | databases |
| databases__initial_sync_status | TEXT | databases.initial_sync_status | databases.initial_sync_status | databases |
| databases__is_audit | BOOLEAN | databases.is_audit | databases.is_audit | databases |
| databases__is_full_sync | BOOLEAN | databases.is_full_sync | databases.is_full_sync | databases |
| databases__is_on_demand | BOOLEAN | databases.is_on_demand | databases.is_on_demand | databases |
| databases__is_sample | BOOLEAN | databases.is_sample | databases.is_sample | databases |
| databases__metadata_sync_schedule | TEXT | databases.metadata_sync_schedule | databases.metadata_sync_schedule | databases |
| databases__name | TEXT | databases.name | databases.name | databases |
| databases__native_permissions | TEXT | databases.native_permissions | databases.native_permissions | databases |
| databases__options | TEXT | databases.options | databases.options | databases |
| databases__points_of_interest | TEXT | databases.points_of_interest | databases.points_of_interest | databases |
| databases__refingerprint | BOOLEAN | databases.refingerprint | databases.refingerprint | databases |
| databases__settings | TEXT | databases.settings | databases.settings | databases |
| databases__timezone | TEXT | databases.timezone | databases.timezone | databases |
| databases__updated_at | TEXT | databases.updated_at | databases.updated_at | databases |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| native_query_snippets__archived | BOOLEAN | native_query_snippets.archived | native_query_snippets.archived | native_query_snippets |
| native_query_snippets__collection_id | NUMERIC | native_query_snippets.collection_id | native_query_snippets.collection_id | native_query_snippets |
| native_query_snippets__content | TEXT | native_query_snippets.content | native_query_snippets.content | native_query_snippets |
| native_query_snippets__created_at | TEXT | native_query_snippets.created_at | native_query_snippets.created_at | native_query_snippets |
| native_query_snippets__creator | OBJECT | native_query_snippets.creator | native_query_snippets.creator | native_query_snippets |
| native_query_snippets__creator_id | NUMERIC | native_query_snippets.creator_id | native_query_snippets.creator_id | native_query_snippets |
| native_query_snippets__description | TEXT | native_query_snippets.description | native_query_snippets.description | native_query_snippets |
| native_query_snippets__entity_id | TEXT | native_query_snippets.entity_id | native_query_snippets.entity_id | native_query_snippets |
| native_query_snippets__id | NUMERIC | native_query_snippets.id | native_query_snippets.id | native_query_snippets |
| native_query_snippets__name | TEXT | native_query_snippets.name | native_query_snippets.name | native_query_snippets |
| native_query_snippets__updated_at | TEXT | native_query_snippets.updated_at | native_query_snippets.updated_at | native_query_snippets |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| users__common_name | TEXT | users.common_name | users.common_name | users |
| users__email | TEXT | users.email | users.email | users |
| users__first_name | TEXT | users.first_name | users.first_name | users |
| users__id | NUMERIC | users.id | users.id | users |
| users__last_name | TEXT | users.last_name | users.last_name | users |