Back to plugin list
azure
Official
Open-core

Azure

The CloudQuery Azure source plugin extracts information from many of the supported services by Microsoft Azure and loads it into any supported CloudQuery destination. Some tables are marked as premium and have a price per 1M rows synced.

Publisher

cloudquery

Repositorygithub.com
Latest version

v12.0.1

Type

Source

Platforms
Date Published

Mar 12, 2024

Price per 1M rows

$10 (premium tables)

free quota

10M rows

  • azure_advisor_recommendation_metadata
  • azure_advisor_recommendations
  • azure_advisor_suppressions
  • azure_analysisservices_servers
  • azure_apimanagement_service
  • azure_appcomplianceautomation_reports
  • azure_appconfiguration_configuration_stores
  • azure_applicationinsights_components
  • azure_applicationinsights_web_tests
  • azure_appservice_certificate_orders
  • azure_appservice_certificates
  • azure_appservice_deleted_web_apps
  • azure_appservice_domains
  • azure_appservice_environments
  • azure_appservice_plans
  • azure_appservice_recommendations
  • azure_appservice_resource_health_metadata
  • azure_appservice_static_sites
  • azure_appservice_top_level_domains
  • azure_appservice_web_apps
    • azure_appservice_web_app_auth_settings
    • azure_appservice_web_app_configurations
    • azure_appservice_web_app_vnet_connections
  • azure_authorization_classic_administrators
  • azure_authorization_provider_operations_metadata
  • azure_authorization_role_assignments
  • azure_authorization_role_definitions
  • azure_automation_account
  • azure_azurearcdata_postgres_instances
  • azure_azurearcdata_sql_managed_instances
  • azure_azurearcdata_sql_server_instances
  • azure_batch_account
  • azure_billing_accounts
  • azure_billing_enrollment_accounts
  • azure_billing_periods
  • azure_botservice_bots
  • azure_cdn_edge_nodes
  • azure_cdn_managed_rule_sets
  • azure_cdn_profiles
    • azure_cdn_endpoints
    • azure_cdn_rule_sets
    • azure_cdn_security_policies
  • azure_cognitiveservices_accounts
    • azure_cognitiveservices_account_skus
    • azure_cognitiveservices_account_usages
    • azure_cognitiveservices_account_models
    • azure_cognitiveservices_account_deployments
    • azure_cognitiveservices_account_private_endpoint_connections
  • azure_cognitiveservices_commitment_plans
  • azure_cognitiveservices_deleted_accounts
  • azure_cognitiveservices_resource_skus
  • azure_compute_availability_sets
  • azure_compute_capacity_reservation_groups
    • azure_compute_capacity_reservations
  • azure_compute_cloud_services
  • azure_compute_disk_accesses
  • azure_compute_disk_encryption_sets
  • azure_compute_disks
  • azure_compute_galleries
  • azure_compute_images
  • azure_compute_restore_point_collections
  • azure_compute_skus
  • azure_compute_snapshots
  • azure_compute_ssh_public_keys
  • azure_compute_virtual_machines
    • azure_compute_virtual_machine_extensions
    • azure_compute_virtual_machine_patch_assessments
  • azure_compute_virtual_machine_scale_sets
    • azure_compute_virtual_machine_scale_set_vms
    • azure_compute_virtual_machine_scale_set_network_interfaces
  • azure_confluent_marketplace_agreements
  • azure_connectedvmware_clusters
  • azure_connectedvmware_datastores
  • azure_connectedvmware_hosts
  • azure_connectedvmware_resource_pools
  • azure_connectedvmware_v_centers
  • azure_connectedvmware_virtual_machines
  • azure_connectedvmware_virtual_machine_templates
  • azure_connectedvmware_virtual_networks
  • azure_consumption_billing_account_balances
  • azure_consumption_billing_account_budgets
  • azure_consumption_billing_account_charges
  • azure_consumption_billing_account_events
  • azure_consumption_billing_account_legacy_usage_details
  • azure_consumption_billing_account_lots
  • azure_consumption_billing_account_marketplaces
  • azure_consumption_billing_account_modern_usage_details
  • azure_consumption_billing_account_reservation_recommendations
  • azure_consumption_billing_account_tags
  • azure_consumption_billing_profile_reservation_details
  • azure_consumption_billing_profile_reservation_recommendations
  • azure_consumption_billing_profile_reservation_summaries
  • azure_consumption_billing_profile_reservation_transactions
  • azure_consumption_subscription_budgets
  • azure_consumption_subscription_legacy_usage_details
  • azure_consumption_subscription_marketplaces
  • azure_consumption_subscription_price_sheets
  • azure_consumption_subscription_reservation_recommendations
  • azure_consumption_subscription_tags
  • azure_containerinstance_container_groups
  • azure_containerregistry_registries
  • azure_containerservice_managed_clusters
    • azure_containerservice_managed_cluster_upgrade_profiles
  • azure_containerservice_snapshots
  • azure_cosmos_database_accounts
    • azure_cosmos_mongo_db_databases
    • azure_cosmos_sql_databases
  • azure_cosmos_locations
  • azure_cosmos_restorable_database_accounts
  • azure_costmanagement_views
    • azure_costmanagement_view_queries
  • azure_customerinsights_hubs
  • azure_dashboard_grafana
  • azure_databox_jobs
  • azure_databricks_access_connectors
  • azure_databricks_operations
  • azure_databricks_workspaces
    • azure_databricks_outbound_network_dependencies_endpoints
    • azure_databricks_private_endpoint_connections
    • azure_databricks_virtual_network_peerings
  • azure_datacatalog_catalogs
  • azure_datadog_marketplace_agreements
  • azure_datadog_monitors
  • azure_datafactory_factories
  • azure_datalakeanalytics_accounts
  • azure_datalakestore_accounts
  • azure_datamigration_services
  • azure_datashare_accounts
  • azure_desktopvirtualization_host_pools
  • azure_devhub_workflow
  • azure_devops_pipeline_template_definitions
  • azure_dnsresolver_dns_forwarding_rulesets
  • azure_dnsresolver_dns_resolvers
  • azure_dns_zones
    • azure_dns_record_sets
  • azure_elastic_monitors
  • azure_engagementfabric_accounts
  • azure_eventgrid_topic_types
  • azure_eventhub_clusters
  • azure_eventhub_namespaces
    • azure_eventhub_namespace_network_rule_sets
  • azure_frontdoor_front_doors
  • azure_frontdoor_managed_rule_sets
  • azure_frontdoor_network_experiment_profiles
  • azure_hanaonazure_sap_monitors
  • azure_hdinsight_clusters
  • azure_healthbot_bots
  • azure_healthcareapis_services
  • azure_hybriddatamanager_data_managers
  • azure_keyvault_keyvault
    • azure_keyvault_keyvault_keys
    • azure_keyvault_keyvault_secrets
  • azure_keyvault_keyvault_managed_hsms
  • azure_kusto_clusters
  • azure_logic_workflows
  • azure_machinelearningservices_workspaces
  • azure_maintenance_configurations
  • azure_maintenance_public_maintenance_configurations
  • azure_managementgroups_entities
  • azure_managementgroups_management_groups
  • azure_mariadb_servers
    • azure_mariadb_server_configurations
  • azure_marketplace_private_store
  • azure_monitor_action_groups
  • azure_monitor_activity_log_alerts
  • azure_monitor_autoscale_settings
  • azure_monitor_log_profiles
  • azure_monitor_metric_alerts
  • azure_monitor_resources
    • azure_monitor_diagnostic_settings
  • azure_monitor_scheduled_query_rules
  • azure_monitor_subscription_diagnostic_settings
  • azure_monitor_tenant_activity_log_alerts
  • azure_monitor_tenant_activity_logs
  • azure_mysqlflexibleservers_servers
    • azure_mysqlflexibleservers_server_configurations
    • azure_mysqlflexibleservers_server_firewall_rules
  • azure_mysql_servers
    • azure_mysql_server_configurations
    • azure_mysql_server_databases
  • azure_network_application_gateways
  • azure_network_application_security_groups
  • azure_network_azure_firewall_fqdn_tags
  • azure_network_azure_firewalls
  • azure_network_bastion_hosts
  • azure_network_bgp_service_communities
  • azure_network_custom_ip_prefixes
  • azure_network_ddos_protection_plans
  • azure_network_dscp_configuration
  • azure_network_express_route_circuits
    • azure_network_express_route_circuit_authorizations
    • azure_network_express_route_circuit_peerings
  • azure_network_express_route_gateways
  • azure_network_express_route_ports
  • azure_network_express_route_ports_locations
  • azure_network_express_route_service_providers
  • azure_network_firewall_policies
  • azure_networkfunction_azure_traffic_collectors_by_subscription
  • azure_network_interfaces
    • azure_network_interface_ip_configurations
  • azure_network_ip_allocations
  • azure_network_ip_groups
  • azure_network_load_balancers
  • azure_network_nat_gateways
  • azure_network_private_endpoints
  • azure_network_profiles
  • azure_network_public_ip_addresses
  • azure_network_public_ip_prefixes
  • azure_network_route_filters
  • azure_network_route_tables
  • azure_network_security_groups
  • azure_network_security_partner_providers
  • azure_network_service_endpoint_policies
  • azure_network_subscription_network_manager_connections
  • azure_network_virtual_appliances
  • azure_network_virtual_hubs
  • azure_network_virtual_network_gateway_connections
  • azure_network_virtual_network_gateways
  • azure_network_virtual_networks
    • azure_network_virtual_network_subnets
  • azure_network_virtual_network_taps
  • azure_network_virtual_routers
  • azure_network_virtual_wans
  • azure_network_vpn_gateways
  • azure_network_vpn_server_configurations
  • azure_network_vpn_sites
  • azure_network_watchers
    • azure_network_watcher_flow_logs
  • azure_network_web_application_firewall_policies
  • azure_nginx_deployments
  • azure_notificationhubs_namespaces
  • azure_operationalinsights_clusters
  • azure_operationalinsights_workspaces
  • azure_peering_service_countries
  • azure_peering_service_locations
  • azure_peering_service_providers
  • azure_policy_assignments
  • azure_policy_data_policy_manifests
  • azure_policy_definitions
  • azure_policy_exemptions
  • azure_policy_set_definitions
  • azure_portal_list_tenant_configuration_violations
  • azure_portal_tenant_configurations
  • azure_postgresqlflexibleservers_servers
    • azure_postgresqlflexibleservers_server_configurations
    • azure_postgresqlflexibleservers_server_firewall_rules
  • azure_postgresqlhsc_server_groups
  • azure_postgresql_servers
    • azure_postgresql_server_configurations
    • azure_postgresql_server_firewall_rules
    • azure_postgresql_databases
  • azure_powerbidedicated_capacities
  • azure_privatedns_private_zones
    • azure_privatedns_private_zone_record_sets
  • azure_providerhub_provider_registrations
  • azure_redhatopenshift_open_shift_clusters
  • azure_redis_caches
  • azure_relay_namespaces
  • azure_reservations_reservation
  • azure_reservations_reservation_order
  • azure_resources_providers
  • azure_resources_resource_groups
  • azure_resources_resources
  • azure_role_management_policy_assignments
  • azure_saas_resources
  • azure_search_services
  • azure_security_adaptive_application_controls
  • azure_security_alerts
  • azure_security_alerts_suppression_rules
  • azure_security_allowed_connections
  • azure_security_applications
  • azure_security_assessments
  • azure_security_assessments_metadata
  • azure_security_automations
  • azure_security_auto_provisioning_settings
  • azure_security_connectors
  • azure_security_contacts
  • azure_security_discovered_security_solutions
  • azure_security_external_security_solutions
  • azure_security_governance_rule
  • azure_security_jit_network_access_policies
  • azure_security_locations
  • azure_security_pricings
  • azure_security_regulatory_compliance_standards
  • azure_security_secure_score_control_definitions
  • azure_security_secure_score_controls
  • azure_security_secure_scores
  • azure_security_settings
  • azure_security_solutions
  • azure_security_sub_assessments
  • azure_security_tasks
  • azure_security_topology
  • azure_security_workspace_settings
  • azure_servicebus_namespaces
    • azure_servicebus_namespace_topics
      • azure_servicebus_namespace_topic_authorization_rules
        • azure_servicebus_namespace_topic_rule_access_keys
  • azure_sql_instance_pools
  • azure_sql_managed_instances
    • azure_sql_managed_instance_encryption_protectors
    • azure_sql_managed_instance_vulnerability_assessments
  • azure_sql_servers
    • azure_sql_server_vulnerability_assessments
    • azure_sql_server_blob_auditing_policies
    • azure_sql_server_admins
    • azure_sql_server_encryption_protectors
    • azure_sql_server_databases
      • azure_sql_server_database_blob_auditing_policies
      • azure_sql_transparent_data_encryptions
      • azure_sql_server_database_threat_protections
      • azure_sql_server_database_vulnerability_assessments
        • azure_sql_server_database_vulnerability_assessment_scans
      • azure_sql_server_database_long_term_retention_policies
    • azure_sql_server_virtual_network_rules
    • azure_sql_server_security_alert_policies
    • azure_sql_server_advanced_threat_protection_settings
    • azure_sql_server_firewall_rules
  • azure_sql_virtual_clusters
  • azure_sqlvirtualmachine_groups
  • azure_sqlvirtualmachine_sql_virtual_machines
  • azure_storage_accounts
    • azure_storage_tables
    • azure_storage_containers
    • azure_storage_blob_services
    • azure_storage_file_shares
    • azure_storage_queues
      • azure_storage_queue_acl
    • azure_storage_queue_services
  • azure_storagecache_caches
  • azure_streamanalytics_streaming_jobs
  • azure_subscription_subscriptions
    • azure_subscription_subscription_locations
  • azure_subscription_tenants
  • azure_support_services
  • azure_support_tickets
  • azure_synapse_workspaces
  • azure_trafficmanager_profiles
  • azure_windowsiot_services
  • azure_workloads_monitors

Azure Advisor Recommendation Metadata

The azure_advisor_recommendation_metadata table shows data for Azure Advisor Recommendation Metadata.

https://learn.microsoft.com/en-us/rest/api/advisor/recommendation-metadata/list?tabs=HTTP#metadataentity

The primary key for this table is id.

Columns
NameType
_cq_iduuid
_cq_parent_iduuid
idutf8
nameutf8
propertiesjson
typeutf8
Subscribe to product updates

Be the first to know about new features.