Providers

Providers are a special type of company and one of the three business entities represented in the COMPANIES view.

Providers are companies with two or more products

Providers are companies with two or more products tracked by Intricately. Think of Providers as a "container" for products from the same company.

Each Provider has its own landing page on intricately.com that lists the provider’s products. Here are a few examples:

• AWS
• Google Cloud Platform
• Microsoft
• Oracle

Example 1

To list all providers and their products you can run the following query:

SELECT   
providers.name as "Provider Name",   
products.name as "Product Name" 
FROM intricately_providers_products providers_products 
INNER JOIN intricately_companies providers ON providers.company_slug = providers_products.provider_slug 
INNER JOIN intricately_companies products ON products.company_slug = providers_products.product_slug 
LIMIT 5;