With the S3 Browser, you can open CSV files in the same way as when selecting them from the hard drive. It is often used as a tool for CSV files management, but setting up Athena is complicated. One of the important advantages of DBeaver’s S3 Browser is the ability to conveniently work with Athena – a service for performing interactive queries in the Amazon S3. In the same way, you can copy any files from the S3 Browser directly to your hard drive and back. For example, you can add scripts previously created in DBeaver to the cloud storage. If you open the Project Explorer, you will be able to drag and drop files from it to the S3 Browser and vice versa. Other types of files are opened with your operating system’s default apps. SQL scripts will be opened in SQL Editor. The file type is recognized automatically. You can view files directly in the S3 Browser. In the two right columns of the S3 Browser, you can see the size of the file in kilobytes and the date and time it was last modified. This menu also allows you to copy or delete the selected file. For example, you can open any selected file by double-clicking on it or using the context menu. You can work with the S3 browser in the same way as with a regular file system. When you open the main folder, you will see a list of subfolders divided by the regions. AWS credentials define the permissions to access to the files. You will see a list of folders whose names correspond with the configurations you have created. To open the S3 Browser, click on the icon with the folder and cloud on it. Read more about creating a configuration in our Cloud Explorer article. If you have several credential sets with access to different databases, you can create as many cloud configurations as you need with different credentials. If you have already created a сonfiguration for the Cloud Explorer, you can use it for the S3 browser without any additional settings. Use the checkboxes to select the ones in which the files you need are stored. If you open the Regions tab, you will see that only one region is selected by default. Then choose an authentication method, and fill out all the required fields. You can do it by clicking on the Cloud icon in the upper left corner of the screen. To get access to S3, you need to create a cloud configuration. At the moment, DBeaver supports Amazon S3, but our team is already working on adding other cloud services. The files you need are stored in S3 or Simple Storage Service that provides object storage through a web service interface. Today we will tell you how to solve this issue with the S3 browser, one of the most important DBeaver Ultimate tools. But for security reasons, the admin can not provide the necessary credentials for this. It is possible to do this with the AWS console. Sometimes company employees need to access the files stored in the AWS.
0 Comments
Leave a Reply. |