LogoLogo
Start Trial
  • Overview
    • What is DeltaStream?
    • Core Concepts
      • Access Control
      • Region
      • SQL
      • Store
      • Database
      • Query
      • Visualizing Data Lineage
      • Function
  • Getting Started
    • Free Trial Quick Start
    • Starting with the Web App
    • Starting with the CLI
  • Tutorials
    • Managing Users and User Roles
      • Inviting Users to an Organization
      • Administering Users in your Organization
      • Using the CLI to Manage User Roles
      • Example: Setting Up Custom Roles for Production and Stage
    • Creating Stores for Streaming Data
    • Using Multiple Stores in Queries
    • Creating Relations to Structure Raw Data
    • Namespacing with Database and Schema
    • Creating and Querying Materialized Views
    • Creating a Function
    • Securing Your Connections to Data Stores
      • Introducing DeltaStream Private Links
      • Creating an AWS Private Link from DeltaStream to your Confluent Kafka Dedicated Cluster
      • Enabling Private Link Connectivity to Confluent Enterprise Cluster and Schema Registry
      • Creating a Private Link from DeltaStream to Amazon MSK
      • Creating a Private Link for RDS Databases
      • Deleting a Private Link
    • Integrations
      • Connecting to Confluent Cloud
      • Databricks
      • PostgreSQL
      • Snowflake
      • WarpStream
    • Serialization
      • Working with ProtoBuf Serialized Data and DeltaStream Descriptors
      • Working with Avro Serialized Data and Schema Registries
      • Configuring Deserialization Error Handling
  • Reference
    • Enterprise Security Integrations
      • Okta SAML Integration
      • Okta SCIM Integration
    • Metrics
      • Prometheus Integration
      • Built-In Metrics
      • Custom Metrics in Functions
    • SQL Syntax
      • Data Formats (Serialization)
        • Serializing with JSON
        • Serializing with Primitive Data Types
        • Serializing with Protobuf
      • Data Types
      • Identifiers and Keywords
      • Command
        • ACCEPT INVITATION
        • CAN I
        • COPY DESCRIPTOR_SOURCE
        • COPY FUNCTION_SOURCE
        • DESCRIBE ENTITY
        • DESCRIBE QUERY
        • DESCRIBE QUERY METRICS
        • DESCRIBE QUERY EVENTS
        • DESCRIBE QUERY STATE
        • DESCRIBE RELATION
        • DESCRIBE RELATION COLUMNS
        • DESCRIBE ROLE
        • DESCRIBE SECURITY INTEGRATION
        • DESCRIBE <statement>
        • DESCRIBE STORE
        • DESCRIBE USER
        • GENERATE COLUMNS
        • GENERATE TEMPLATE
        • GRANT OWNERSHIP
        • GRANT PRIVILEGES
        • GRANT ROLE
        • INVITE USER
        • LIST API_TOKENS
        • LIST DATABASES
        • LIST DESCRIPTORS
        • LIST DESCRIPTOR_SOURCES
        • LIST ENTITIES
        • LIST FUNCTIONS
        • LIST FUNCTION_SOURCES
        • LIST INVITATIONS
        • LIST METRICS INTEGRATIONS
        • LIST ORGANIZATIONS
        • LIST QUERIES
        • LIST REGIONS
        • LIST RELATIONS
        • LIST ROLES
        • LIST SCHEMAS
        • LIST SCHEMA_REGISTRIES
        • LIST SECRETS
        • LIST SECURITY INTEGRATIONS
        • LIST STORES
        • LIST USERS
        • PRINT ENTITY
        • REJECT INVITATION
        • REVOKE INVITATION
        • REVOKE PRIVILEGES
        • REVOKE ROLE
        • SET DEFAULT
        • USE
      • DDL
        • ALTER API_TOKEN
        • ALTER SECURITY INTEGRATION
        • CREATE API_TOKEN
        • CREATE CHANGELOG
        • CREATE DATABASE
        • CREATE DESCRIPTOR_SOURCE
        • CREATE ENTITY
        • CREATE FUNCTION_SOURCE
        • CREATE FUNCTION
        • CREATE INDEX
        • CREATE METRICS INTEGRATION
        • CREATE ORGANIZATION
        • CREATE ROLE
        • CREATE SCHEMA_REGISTRY
        • CREATE SCHEMA
        • CREATE SECRET
        • CREATE SECURITY INTEGRATION
        • CREATE STORE
        • CREATE STREAM
        • CREATE TABLE
        • DROP API_TOKEN
        • DROP CHANGELOG
        • DROP DATABASE
        • DROP DESCRIPTOR_SOURCE
        • DROP ENTITY
        • DROP FUNCTION_SOURCE
        • DROP FUNCTION
        • DROP METRICS INTEGRATION
        • DROP RELATION
        • DROP ROLE
        • DROP SCHEMA
        • DROP SCHEMA_REGISTRY
        • DROP SECRET
        • DROP SECURITY INTEGRATION
        • DROP STORE
        • DROP STREAM
        • DROP USER
        • UPDATE ENTITY
        • UPDATE SCHEMA_REGISTRY
        • UPDATE SECRET
        • UPDATE STORE
      • Query
        • APPLICATION
        • Change Data Capture (CDC)
        • CREATE CHANGELOG AS SELECT
        • CREATE STREAM AS SELECT
        • CREATE TABLE AS SELECT
        • Function
          • Built-in Functions
          • Row Metadata Functions
        • INSERT INTO
        • Materialized View
          • CREATE MATERIALIZED VIEW AS
          • SELECT (FROM MATERIALIZED VIEW)
        • Query Name and Version
        • Resume Query
        • RESTART QUERY
        • SELECT
          • FROM
          • JOIN
          • MATCH_RECOGNIZE
          • WITH (Common Table Expression)
        • TERMINATE QUERY
      • Sandbox
        • START SANDBOX
        • DESCRIBE SANDBOX
        • STOP SANDBOX
      • Row Key Definition
    • Rest API
Powered by GitBook
On this page
  • Syntax
  • Description
  • Arguments
  • Examples
  1. Reference
  2. SQL Syntax
  3. Command

SET DEFAULT

PreviousREVOKE ROLENextUSE

Last updated 5 months ago

Syntax

SET DEFAULT [DATABASE | ORGANIZATION | ROLE | SCHEMA | STORE] object_name;

Description

This sets the , , , , or as the user’s default. Changing defaults does not affect the current session’s context, and you can use to change the current context.

Entering a new user session has the same affect as changing it with .

Any object used to set as default must already exist and be accessible by the user.

Arguments

object_name

Name of the entity to set as a default. If the name is case sensitive you must wrap it in double quotes; otherwise, the system uses the lowercase name.

Examples

Set a new default database

The following changes the user’s default database to user_db:

main_db.public/demostore# LIST DATABASES;
+---------+-------------+----------+-------------------------------+
|  Name   |  Is Default |  Owner   |  Created At                   |
+=========+=============+==========+===============================+
| user_db | false       | orgadmin | 2024-06-05 19:41:23 +0000 UTC |
+---------+-------------+----------+-------------------------------+
| main_db | true        | sysadmin | 2023-08-09 21:28:40 +0000 UTC |
+---------+-------------+----------+-------------------------------+
main_db.public/demostore# SET DEFAULT DATABASE user_db;
+---------+---------+----------+------------------------------------------+
|  Type   |  Name   |  Command |  Summary                                 |
+=========+=========+==========+==========================================+
| default | user_db | UPDATE   | Default database was successfully        |
|         |         |          | updated to user_db                       |
+---------+---------+----------+------------------------------------------+

Set a new default schema

The following changes the user’s default schema to demodb.Analytics within the current database, demodb:

demodb.public/demostore# LIST SCHEMAS;
+-----------+-------------+----------+-------------------------------+
|  Name     |  Is Default |  Owner   |  Created At                   |
+===========+=============+==========+===============================+
| public    | false       | sysadmin | 2023-08-09 21:28:40 +0000 UTC |
+-----------+-------------+----------+-------------------------------+
| Analytics | false       | orgadmin | 2023-08-18 16:36:16 +0000 UTC |
+-----------+-------------+----------+-------------------------------+
demodb.public/demostore# SET DEFAULT SCHEMA "Analytics";
+---------+-----------+----------+------------------------------------------+
|  Type   |  Name     |  Command |  Summary                                 |
+=========+===========+==========+==========================================+
| default | Analytics | UPDATE   | Default schema was successfully updated  |
|         |           |          | to main_db.Analytics                     |
+---------+-----------+----------+------------------------------------------+

Set a new default store

The following changes the user’s default store to sf_east_2 for future sessions:

main_db.public/pubmsk# LIST STORES;
+------------+------------+----------------+--------+-------------+----------+-------------------------------+-------------------------------+
|  Name      |  Type      |  Access Region |  State |  Is Default |  Owner   |  Created At                   |  Updated At                   |
+============+============+================+========+=============+==========+===============================+===============================+
| sf_east_2  | Snowflake  | AWS us-east-1  | ready  | false       | sysadmin | 2024-06-12 22:39:03 +0000 UTC | 2024-06-12 22:39:03 +0000 UTC |
+------------+------------+----------------+--------+-------------+----------+-------------------------------+-------------------------------+
| pubmsk     | Kafka      | AWS us-east-1  | ready  | true        | sysadmin | 2023-08-09 21:27:32 +0000 UTC | 2024-05-24 20:53:58 +0000 UTC |
+------------+------------+----------------+--------+-------------+----------+-------------------------------+-------------------------------+
| dbx_east_1 | Databricks | AWS us-east-1  | ready  | false       | sysadmin | 2024-02-09 22:28:30 +0000 UTC | 2024-02-09 22:28:30 +0000 UTC |
+------------+------------+----------------+--------+-------------+----------+-------------------------------+-------------------------------+
| cc_store   | Confluent  | AWS us-east-1  | ready  | false       | sysadmin | 2024-05-22 21:02:38 +0000 UTC | 2024-05-22 23:09:50 +0000 UTC |
|            | Kafka      |                |        |             |          |                               |                               |
+------------+------------+----------------+--------+-------------+----------+-------------------------------+-------------------------------+
main_db.public/pubmsk# SET DEFAULT STORE sf_east_2;
+---------+-----------+----------+------------------------------------------+
|  Type   |  Name     |  Command |  Summary                                 |
+=========+===========+==========+==========================================+
| default | sf_east_2 | UPDATE   | Default store was successfully updated   |
|         |           |          | to sf_east_2                             |
+---------+-----------+----------+------------------------------------------+

Set a new default role

The following changes the user’s default role to useradmin for future sessions:

main_db.public/demostore# LIST ROLES;
+-----------+-------------+-------------+-------------------------------+-------------------------------+
|  Name     |  Is Current |  Is Default |  Created At                   |  Updated At                   |
+===========+=============+=============+===============================+===============================+
| orgadmin  | true        | false       | 2023-08-09 21:25:57 +0000 UTC | 2023-08-09 21:25:57 +0000 UTC |
+-----------+-------------+-------------+-------------------------------+-------------------------------+
| sysadmin  | false       | true        | 2023-08-09 21:25:57 +0000 UTC | 2023-08-09 21:25:57 +0000 UTC |
+-----------+-------------+-------------+-------------------------------+-------------------------------+
| public    | false       | false       | 2023-08-09 21:25:57 +0000 UTC | 2023-08-09 21:25:57 +0000 UTC |
+-----------+-------------+-------------+-------------------------------+-------------------------------+
| useradmin | false       | false       | 2023-08-09 21:25:57 +0000 UTC | 2023-08-09 21:25:57 +0000 UTC |
+-----------+-------------+-------------+-------------------------------+-------------------------------+
| securitya | false       | false       | 2023-08-09 21:25:57 +0000 UTC | 2023-08-09 21:25:57 +0000 UTC |
| dmin      |             |             |                               |                               |
+-----------+-------------+-------------+-------------------------------+-------------------------------+
| rol1      | false       | false       | 2024-07-18 01:04:09 +0000 UTC | 2024-07-18 01:04:09 +0000 UTC |
+-----------+-------------+-------------+-------------------------------+-------------------------------+
| rol2      | false       | false       | 2024-07-18 01:14:18 +0000 UTC | 2024-07-18 01:14:18 +0000 UTC |
+-----------+-------------+-------------+-------------------------------+-------------------------------+
main_db.public/demostore# SET DEFAULT ROLE useradmin;
+---------+-----------+----------+------------------------------------------+
|  Type   |  Name     |  Command |  Summary                                 |
+=========+===========+==========+==========================================+
| default | useradmin | UPDATE   | Default role was successfully updated    |
|         |           |          | to useradmin                             |
+---------+-----------+----------+------------------------------------------+

Set a new default organization

The following changes the user’s default organization to mr_prod, using its ID field, for future sessions:

demodb.public/demostore# LIST ORGANIZATIONS;
+--------------------------------------+----------+-------------+-------------+--------------+--------------------+-------------------------------+
|  ID                                  |  Name    |  Is Current |  Is Default |  Description |  Profile Image Uri |  Created At                   |
+======================================+==========+=============+=============+==============+====================+===============================+
| caab10ef-5c55-4e6b-906b-29a9dae9a94d | my_org   | true        | true        | <null>       | <null>             | 2024-07-02 21:16:22 +0000 UTC |
+--------------------------------------+----------+-------------+-------------+--------------+--------------------+-------------------------------+
| c8e61681-1461-4d76-b565-542b5e9e1fd3 | mr_prod  | false       | false       | <null>       | <null>             | 2023-09-19 16:17:03 +0000 UTC |
+--------------------------------------+----------+-------------+-------------+--------------+--------------------+-------------------------------+
main_db.public/demostore# SET DEFAULT ORGANIZATION c8e61681-1461-4d76-b565-542b5e9e1fd3;
+---------+---------+----------+------------------------------------------+
|  Type   |  Name   |  Command |  Summary                                 |
+=========+=========+==========+==========================================+
| default | mr_prod | UPDATE   | Default organization was successfully    |
|         |         |          | updated to mr_prod                       |
+---------+---------+----------+------------------------------------------+
database
store
USE
USE
organization
role
schema