Select error running sample queries

The sample queries provided as part of ATTOM Cloud are designed to run against the standard (5-county) trial database provided to everyone evaluating ATTOM Cloud and those that have purchased ATTOM Cloud.

Those same queries will only run against the ATTOM CLoud (national) database if have purchased national data for all the datasets used by the query. If you don't have access to one of the tables/views included in the sample query, you will receive a message similar to the following

Expanded Trial

If you have requested an expanded trial, this will be restricted to a subset of geographies and a subset of datasets. This is accomplished by creating a set of custom views that expose the data requested. ATTOM's support team will contact you to advise the names of those custom views. These typically consist of the original table./view with a four-digit number assigned to your company that is then appended to the end (e.g. PropertyFeauture_1234).

Limited Coverage Paid Subscription

If you have purchased ATTOM Cloud data you may have only 

  • Limited geographies such as one or more counties or states;
  • A limited subset of records such as history for the last 3 years, or mortgage-only records from deeds and mortgages

When a subset of data is purchased we implement this by creating a set of custom views that expose the included data.ATTOM's support team will contact you to advise the names of those custom views. These typically consist of the original table./view with a four-digit number assigned to your company that is then appended to the end (e.g. PropertyFeauture_1234).

Modifying Queries

If you have been provided with customized views, it will be necessary to modify the sample queries to include the custom view names in place of the base table/view. This will usually be in the part of the SQL query containing the FROM and JOIN statements. Having modified the query, you can then save the query as your own custom query.

Note: Your ATTOM Cloud account often includes access to lookup (dimension) tables starting with "Dim" e.g. DimPropertyType. Most of these lookup tables do not need to be customized. You should not have to rename these in your query.

The following code snippet shows three ATTOM cloud tables being used:

FROM
    ADW.PropertyFeature PF
    INNER JOIN ADW.DimCounty DC ON PF.CountyKey = DC.CountyKey
    INNER JOIN ADW.ForeclosureDetail FD ON FD.[ATTOM ID] = PF.[ATTOM ID]

The code is modified to use the names of the custom views assigned

FROM
    ADW.PropertyFeature_1234 PF  -- Property feature tables has been customized
    INNER JOIN ADW.DimCounty DC ON PF.CountyKey = DC.CountyKey  -- DimCounty is not customized
    INNER JOIN ADW.ForeclosureDetail_1234 FD ON FD.[ATTOM ID] = PF.[ATTOM ID] -- ForeclosureDetails table has been customized

It is a good idea to assign aliases to tables/views in this section to minimize the amount of code that needs to be changed to support custom views.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.