Snowflake
DBeaverDevOps edited this page Mar 18, 2024
·
2 revisions
You can read more about the Snowflake database in the Snowflake documentation.
There are several ways to configure a database connection.
Connection parameters
Parameter | Description | Example |
---|---|---|
Host | Server host name | https://account.region.snowflakecomputing.com |
Post number | Server listener port | 443 (default) |
Database* | Database name | SNOWFLAKE_SAMPLE_DATA |
Warehouse* | Cluster of compute resources in Snowflake. Warehouses are required for queries, as well as all DML operations, including loading data into tables | SNOWFLAKE |
Schema* | Schema name | SAMPLE_DATA |
*Click on the "Test Connection" button to load the warehouse/database/schema list from the server.
Parameter | Description | Example |
---|---|---|
Username | Database user name | ADMIN |
Password | Database user password | ***** |
Save password | Saves the user/password information in the local DBeaver configuration | |
Role | Role for connection | SYS |
Authenticator | Authenticator parameter/option | https://<okta_account_name>.okta.com |
Parameter | Description | Example |
---|---|---|
Username | Database user name | ADMIN |
Private key | Path to encrypted or unencrypted private key | C:/Users/admin/Downloads/rsa_key.p8 |
Key Password | Private key password | ***** |
Save password | Saves the user/password information in the local DBeaver configuration | |
Role | Role for connection | SYS |
Connection with the help of an external browser will be used.
Parameter | Description | Example |
---|---|---|
Username | Database user name | ADMIN |
Role | Role for connection | SYS |
You can use preconfigured connection profile here.
DBeaver provides an opportunity to view and manipulate such types of metadata:
- Databases
- Schemas
- Data types
- Tables
- Views
- Procedures and functions
- Sequences
- Stages
- Pipes
- Streams
- Tasks
- Materialized Views
Table statistics are also available only in PRO DBeaver versions. As well as expanded metadata about tables and schemes.
- Installation
- Application Window Overview
- Views
- Database Object Editor
- SQL Editor
- Search
- Schema compare
- Using Liquibase in DBeaver
- Data compare
- MockData generation
- Spelling
- Dashboards, DB monitoring
- Projects
- Managing Master password
- Security in PRO products
- Certificate Management
- Bookmarks
- Shortcuts
- Accessibility
- Sample Database
-
Database Connections
- Edit Connection
- Invalidate/Reconnect to Database
- Disconnect from Database
- Change current user password
- Advanced settings
- Cloud configuration settings
- Local Client Configuration
- Connection Types
- Configure Connection Initialization Settings
- Tableau integration
- Transactions
- Drivers
- Tasks
- Cloud Explorer
- Cloud Storage
- Classic
- Cloud
- Changing interface language
- DBeaver extensions - Office, Debugger, SVG
- Installing extensions - Themes, version control, etc
- User Interface Themes
- Command Line
- Reset UI settings
- Reset workspace
- Troubleshooting system issues
- Posting issues
- Log files
- JDBC trace
- Thread dump
- Managing connections
- Managing variables
- Managing drivers
- Managing preferences
- Managing restrictions
- Windows Silent Install
- Snap installation