<< Click to Display Table of Contents >> Navigation:  Sources > ZIP

It is possible to select from files inside ZIP archive. F.e. if we have sales_data.zip containing four JSON files - customers, orders, products and sales, we can write:

 

select c.name, o.orderId, o.date, p.name, s.quantity 
from
  sales_data.sales s
  join sales_data.orders o on o.orderid=s.orderid
  join sales_data.customers c on c.customerid=o.customerid
  join sales_data.products p on p.productid=s.productid