Microsoft SQL
Steps to prepare and connect to MS-SQL
Lightup account setup
Lightup supports connections to MS-SQL 2012.
Lightup needs a user account that can query data and metadata for all tables and views you want to monitor. You might already have a user set up that will work, or you might need to create one. We recommend you use a role to provide sufficient privileges to the Lightup user.
Create a Lightup user
Run the following T-SQL, substituting in a password for the Lightup user.
CREATE LOGIN lightup WITH PASSWORD = '********';
GO
CREATE USER lightup FOR LOGIN lightup;
GO
CREATE ROLE lightup_role;
GO
GRANT SELECT ON SCHEMA :: [SELECT SCHEMA_NAME(schema_id) AS schema_name FROM sys.objects] TO lightup_role;
GO
GRANT ROLE lightup_role TO lightup;
GO
Configure connector
- Host Name - The hostname for the datasource (check the browser address bar; you want the string between // and /. Example:
https://
host.na.me
/
- Database Name - The name of the database you're connecting to. Each datasource can only connect to one database. If you need to connect to more than one, you'll need to create a datasource for each.
- Username - Enter lightup.
- Password - The lightup account's password.
Advanced/Schema scan frequency
You can adjust how often scans run for a datasource.
- In section 3 - Advanced, select a value for Schema scan frequency: Hourly, Daily, or Weekly.
Query Governance
Microsoft-SQL datasources support the Query History, Scheduling, Enable data storage, Maximum backfill duration, and Maximum distinct values settings. For steps, see Set query governance settings for a datasource.
Metadata metrics
For information about supported metadata metrics, see Metadata metric types.
Date/time data types
These MS-SQL date/time data types are supported:
Object types
These MS-SQL object types are supported:
Updated about 1 month ago