Skip to main content

Ctrl+K

Site Navigation

Getting Started
Deployment
How to
Reference
Changelog

GitHub
Twitter
LinkedIn
Medium

Site Navigation

Getting Started
Deployment
How to
Reference
Changelog

GitHub
Twitter
LinkedIn
Medium

Ctrl+K

Section Navigation

API
- atoti
  - Aggregation functions
    - count_distinct()
    - long()
    - max()
    - max_member()
    - mean()
    - median()
    - min()
    - min_member()
    - prod()
    - quantile()
    - short()
    - single_value()
    - square_sum()
    - std()
    - sum()
    - sum_product()
    - var()
  - AggregateProvider
  - AggregatesCache
    - capacity
  - App extensions
  - Array functions
    - len()
    - max()
    - mean()
    - min()
    - n_greatest()
    - n_greatest_indices()
    - n_lowest()
    - n_lowest_indices()
    - negative_values()
    - nth_greatest()
    - nth_lowest()
    - positive_values()
    - prefix_sum()
    - prod()
    - quantile()
    - quantile_index()
    - replace()
    - sort()
    - std()
    - sum()
    - var()
  - ClientSideEncryptionConfig
  - Column
    - data_type
    - default_value
    - isin()
    - isnull()
    - name
  - Session config
  - Cube
  - CubeContext
  - Cubes
  - DirectQuery
  - Experimental features
  - General functions
    - at()
    - date_diff()
    - date_shift()
    - filter()
    - first()
    - last()
    - lookup()
    - parent_value()
    - rank()
    - shift()
    - switch()
    - total()
    - where()
  - Hierarchies
  - Hierarchy
    - dimension
    - isin()
    - levels
    - name
    - slicing
    - virtual
    - visible
  - Level
    - data_type
    - dimension
    - hierarchy
    - isin()
    - isnull()
    - name
    - order
  - Levels
  - Math functions
    - abs()
    - ceil()
    - cos()
    - erf()
    - erfc()
    - exp()
    - floor()
    - isnan()
    - log()
    - log10()
    - max()
    - min()
    - round()
    - sin()
    - sqrt()
    - tan()
  - Measure
    - data_type
    - description
    - folder
    - formatter
    - isnull()
    - name
    - visible
  - Measures
  - Level order
    - CustomOrder
    - NaturalOrder
  - Custom endpoints
    - HttpRequest
    - User
  - Aggregation scopes
  - Session
  - String functions
    - concat()
  - Table
    - append()
    - columns
    - drop()
    - head()
    - join()
    - keys
    - load_arrow()
    - load_csv()
    - load_kafka()
    - load_numpy()
    - load_pandas()
    - load_parquet()
    - load_spark()
    - load_sql()
    - name
    - scenario
    - scenarios
  - Tables
    - schema
  - Data types
- atoti-aws
  - Client side encryption
    - AwsKeyPair
    - AwsKmsConfig
- atoti-azure
  - Client side encryption
    - AzureKeyPair
- atoti-directquery-bigquery
- atoti-directquery-clickhouse
- atoti-directquery-databricks
- atoti-directquery-mssql
- atoti-directquery-redshift
- atoti-directquery-snowflake
- atoti-directquery-synapse
- atoti-gcp
- atoti-jupyterlab
- atoti-kafka
- atoti-query
  - Auth
  - BasicAuthentication
  - ClientCertificate
  - OAuth2ResourceOwnerPasswordAuthentication
  - QueryCube
    - hierarchies
    - levels
    - measures
    - name
    - query()
  - QueryCubes
  - QueryHierarchies
  - QueryHierarchy
    - dimension
    - isin()
    - levels
    - name
    - slicing
  - QueryLevel
    - dimension
    - hierarchy
    - isin()
    - isnull()
    - name
  - QueryLevels
  - QueryMeasure
    - description
    - folder
    - formatter
    - isnull()
    - name
    - visible
  - QueryMeasures
  - QueryResult
    - style
  - QuerySession
    - cubes
    - link
    - query_mdx()
    - url
    - widget
  - Security
  - TokenAuthentication
- atoti-sql
  - Drivers

Reference
atoti_directquery_mssql
atoti_directquery_mssql.MsSqlConnection

atoti_directquery_mssql.MsSqlConnection#

class atoti_directquery_mssql.MsSqlConnection#

Connection to an external Microsoft SQL Server database.

Use atoti.Session.connect_to_external_database() to create one.

Tables of the external database.

previous

atoti_directquery_mssql

next

atoti_directquery_mssql.MsSqlConnection.tables

EULA Privacy policy Terms of Use Contact