The only setup required for using Canvas is connecting your data warehouse. Canvas will use this connection to list all the tables and views in your warehouse, and then to query for data when requested. Canvas never accesses data that you don't request, never writes to your warehouse, and never stores your data. You can read more about Canvas' security practices here.
Canvas currently supports three data warehouses: