![]() Option number two is to go to your Redshift Web console where you can find it under General information. There are 2 ways of obtaining this information, first by running SQL statement In order for your consumer cluster to see and use data share created in previous steps, you will need to run the GRANT permission and you will also need the cluster namespace GUID of your consumer cluster. Once you have added all the objects you wish to share to data share, you should then configure permissions. In case you wish to remove some of the tables from your data share, you can do this by running the statement below:ĪLTER DATASHARE ReportingDatashare REMOVE TABLE schema_name.table_name If you want to share all objects within one schema you can run:ĪLTER DATASHARE SalesDatashare ADD ALL TABLES IN SCHEMA reporting_datamart Note: You always start by first adding schemas you will share and then tables and views.Ģ.ĚLTER DATASHARE ReportingDatashare ADD SCHEMA reporting_datamart ģ.ĚLTER DATASHARE ReportingDatashare ADD TABLE reporting_datamart.sales Second step is to add all the schemas tables and views you want to share with the other cluster, the consumer cluster. This process starts on your Production cluster where you need to first create the data share. With your new consumer cluster up and running, you can start with data sharing setup. This will give you a bigger number of data slices for a much better performance when it comes to reading the data. If your new cluster needs to be smaller than your current cluster, create the new cluster the same size as your production and then use elastic resize to go down to the number of nodes you need. Analyze your current workload and users that will move to the new cluster while also analyzing any of the current issues that you would like to eliminate by this move.Ĭonsider this when creating your new cluster: ![]() This information should already be available to you in your current production cluster. You can make this estimation based on the system that will use this shared cluster as well as the number of users you will have. Now we can start with the actual setup and configuration of your shared cluster.įirst thing you need to do is estimate the size of the new cluster. This will have security implications for your environment.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |