AWS Redshift 連線教學

莉森羊
莉森羊
Aug 22, 2017 · 2 min read

需求說明

連線至Redshift並進行DB查詢

實作時間

2016.09

參考資源

AWS 官方文件

連線步驟

Step 1 : 安裝 SQL Workbench/J

下載網址:http://www.sql-workbench.net/

Step 2:下載RedshiftJDBC41

下載網址:https://s3.amazonaws.com/redshift-downloads/drivers/RedshiftJDBC41-1.1.17.1017.jar

Step 3:設定jdbc連線

SQLWorkbench 設定

Driver 選擇 :

  • 啟動SQLWorkbench
  • 第一次使用者,先至紅框處Manage Drivers 將剛下載的RedshiftJDBC41 jar檔新增至Driver

於左紅框處填入

URL、Username、Password

測試連線

#查詢DB內現有表格

)
Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade