ezyVet Data Lake and site data access
ezyVet Data Lake automatically has data from all ezyVet sites of your organization.
Access to all site data is because each ezyVet site of your organization connects and syncs to a dedicated MySQL database of ezyVet Data Lake.
Because ezyVet Data Lake has all data of all ezyVet sites, it is not necessary to manually put together the data of each site to do reporting and data visualization.
To connect to ezyVet Data Lake, applicable staff of your organization use the database connection URL of the MySQL database. ezyVet staff will give you the database connection URL and the related username and password.
To get access to ezyVet Data Lake data, applicable staff of your organization use SQL tools to make SQL queries. SQL queries for ezyVet Data Lake:
- Have no limit for query length
- Have no limit for data volume
- Have no limit for how frequently that staff do the query
Note: The MySQL database of ezyVet Data Lake is read-only.
Note: The MySQL database of ezyVet Data Lake puts the data of each connected site in a dedicated schema.
Applicable staff that would use ezyVet Data Lake directly to get access to data include:
- Business analysts
- Data scientists
- Data analysts
- Machine learning staff
ezyVet recommends that staff who use ezyVet Data Lake directly know how to make SQL queries. If your organization wants to use ezyVet Data Lake for data visualization, ezyVet recommends that staff know how to use data visualization tools.
Note: ezyVet staff do not make SQL queries and do not make data visualization dashboards for you. But ezyVet staff can give initial information that helps you know how to start. For example, ezyVet staff:
- Can tell you about the data structures and table joins
- Can give you examples of SQL queries