Definitions are used to track and store detailed information about the databases or files we work with. In this section, we’ll walk you through the process of connecting to a pre-configured database connection. We’ll also explore how to scan the database, capture its details, and leverage the insights gained to make informed decisions about the next steps in managing and optimising your data.
To create a new definition:
- Navigate to the Data Dictionary and click +New Definition
- Provide a Name & Description and choose Database. Click ‘Next Step’ when ready.
- Pick ‘Existing Connection’ and choose the previously set-up connection profile
If the database connection has a scan already, it will show here. If no scan is available or you are unsure, click the toggle for 'Trigger new scan'. - Click ‘Next Step→’ and ‘Finish’
Once completed you will have a new 'Definition' linked to a 'Connection Profile' with a completed 'Scan'.
- When finished click ‘Go to Definition’
You will see the current version, table details and additional actions you can now perform against the Definition.
The version and schema within the ‘Content’ tab will hold various scanned information. You can choose different versions or schemas from these drop downs.
Exercise 3
- Create a new definition based off the scan that you conducted in Exercise 2
Need help or want to check your work? Check the solution video here.