gospace DOCS
gospace.comHelp
  • Welcome to gospace
  • Overview
    • Our mission
    • Features overview
      • AI Driven Workplace Management
      • Manual scheduling
      • Auto-schedule
      • Auto-allocate
    • Simulate a digital twin of your building
  • INTEGRATIONS
    • Overview
    • Connect your integration
      • SFTP
      • CISCO Meraki
      • Snowflake
      • Microsoft AD
    • Map your directory
      • Users
      • Teams
      • Users with teams
      • Custom mappings and filters
    • How to map your occupancy data
    • SSO
      • Domain verification
      • Microsoft
      • OKTA SSO Configuration Guide (OIDC)
  • Admin
    • Guides
      • Guide to your first evolve
    • Get started
      • Register an account
      • Understand your divisions
      • Create a location
      • Create a Layer
      • Zones
      • Rooms
    • Labels & connections
    • People
    • Teams
    • Locations
      • Settings: Notifications
      • Settings: Schedule
    • Workplace
      • Allocations
      • Space settings
      • Connections
    • Admin
      • Notification toggles
      • Domain verification
      • Roles
  • User Guides
    • Overview
    • How to schedule
      • Schedule space
      • Schedule a team room for a day
      • Schedule a meeting
    • Create a custom team
    • View your schedule
      • View a teams schedule
      • View a users schedule
    • Profile settings
  • What's new
    • Release notes
      • v1.0.0-beta
      • v1.0.1-beta
      • v1.0.96-beta
      • v2.0.0-beta
      • v2.0.2
      • v2.0.3
      • v2.0.4
      • v2.0.6
      • v2.0.7
      • v2.0.8
      • v2.0.9
      • v2.1.0
      • v2.2.0
      • v2.2.1
      • v2.2.2
      • v2.2.3
  • Enterprise
    • Support
      • Standard Support
      • Enterprise Support
Powered by GitBook
On this page
  1. INTEGRATIONS
  2. Connect your integration

Snowflake

Connect securely and sync People, Teams and Attendance

Last updated 1 year ago

As an Admin with integrations permissions, you can sync your occupancy data or directory via Snowflake.

If using Snowflake for Directory this means your active directory can be seamlessly populated in gospace AI, so you can start to automate for all your users, and map them to teams without any manual inp

If using Snowflake for occupancy this means your real-time occupancy data will be synced with the gospace AI platform for AIDRA to learn and improve your forecasting for smarter space allocation.

To begin, click on either "Snowflake - location occupancy data" for real-time occupancy or "Snowflake - user management" for directory on the integrations page. You'll then see the below.

Find your account name

To find the account name for an account, you can use Snowsight or SQL.

Snowsight

  1. Open the account selector and review the list of accounts that you previously signed in to.

  2. Locate the account for which you want to copy the account name.

  3. Hover over the account to view additional details, and then select the copy icon to copy the account identifier in the format <orgname>.<account_name> to your clipboard.

SQL

Role

As an admin you can use any role your Snowflake organisation has, as long as the role has the necessary permissions to access the data being imported into gospace, the default role for Snowflake is ACCOUNTADMIN, otherwise just navigate to Admin<Users&Roles, and select the role with correct permissions.

Authentication

For authentication, please use your Snowflake username and password to configure the connection.

If everything looks good, click "Continue" to create your Snowflake integration. gospace will then test the connection to your Snowflake server and verify that it can successfully authenticate and access the specified file path. If the connection test is successful, your Snowflake integration is ready to start mapping to import your directory, or sync your occupancy data.

Next steps:

To retrieve the name of the current account, execute the function.

To retrieve the organization of the current account, execute the function.

For further help please refer to the Snowflake documentation here:

For documentation on finding your role find the roles within your organisation here:

CURRENT_ACCOUNT_NAME
CURRENT_ORGANIZATION_NAME
https://docs.snowflake.com/en/user-guide/admin-account-identifier
https://docs.snowflake.com/en/sql-reference/sql/show-roles#examples
Map your directory