Table: supabase_project_custom_hostname - Query Supabase Project Custom Hostnames using SQL
A Supabase Project Custom Hostname is an attribute of a Supabase project, which allows users to associate custom domain names with their projects. It enables the customization of the project's URL, thereby enhancing its accessibility and user-friendliness. This feature contributes to the flexibility and scalability of Supabase projects.
Table Usage Guide
The supabase_project_custom_hostname
table provides insights into the custom domain names associated with a Supabase project. As a project manager or developer, you can explore details about these custom hostnames through this table, including their verification status, creation time, and associated project ID. Utilize it to manage and monitor the custom domain names of your Supabase projects.
Examples
Basic info
Explore which custom hostnames are associated with your Supabase projects, along with their status and creation date. This can be useful in managing and tracking your project's custom domain configurations.
select custom_hostname, status, data ->> 'created_at' as created_at, project_idfrom supabase_project_custom_hostname;
select custom_hostname, status, json_extract(data, '$.created_at') as created_at, project_idfrom supabase_project_custom_hostname;
List custom hostname that are yet to start
Discover the segments that include custom hostnames in your projects that are yet to begin. This is beneficial in managing project timelines and identifying potential delays.
select custom_hostname, status, project_idfrom supabase_project_custom_hostnamewhere status = '1_not_started';
select custom_hostname, status, project_idfrom supabase_project_custom_hostnamewhere status = '1_not_started';
List custom hostname created in last 3 days
Uncover the details of recent custom hostnames to monitor the development of your projects. This is particularly useful for keeping track of any new custom hostnames that have been created within the last three days.
select custom_hostname, status, data ->> 'created_at' as created_at, project_idfrom supabase_project_custom_hostnamewhere (data ->> 'created_at') :: timestamp > (current_date - interval '3 days');
select custom_hostname, status, json_extract(data, '$.created_at') as created_at, project_idfrom supabase_project_custom_hostnamewhere datetime(json_extract(data, '$.created_at')) > datetime(julianday('now') - 3);
Schema for supabase_project_custom_hostname
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
custom_hostname | text | The custom hostname. | |
data | jsonb | Specifies the custom hostname object for the specified project. | |
project_id | text | The ID of the project. | |
status | text | The status of the hostname. |
Export
This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.
You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh
script:
/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- supabase
You can pass the configuration to the command with the --config
argument:
steampipe_export_supabase --config '<your_config>' supabase_project_custom_hostname